Setting the object properties

It's now time to peek into some of the object-level properties that affect the QlikView document's appearance. The properties we are most interested in at this point are:

  • Caption colors
  • Caption font

Let's see what these are.

Caption colors and style

By default, almost every object in the QlikView document has a caption bar at the top, unless we choose to explicitly hide it. Since the caption bar will be visible for most of our objects, let's apply a touch of corporate identity by setting the default caption color to HighCloud Blue and by selecting a custom styling mode.

Changing the caption colors

Follow these steps to apply a new formatting style to caption bars:

  1. Right-click on any of the listboxes on the sheet, for example, Carrier's Operating Region.
  2. Select Properties… and navigate to the Caption tab.

Two types of caption colors can be set: one for when the object is Inactive and one for when the object is Active. An active object is the one on which the user has last clicked, while all of the others are inactive. Since we are not interested in visually identifying the current state of an object, we will apply the same color for both options:

  1. Click on the Background Color button on the Inactive Caption section to open up the Color Area dialog window.
  2. Make sure the radio buttons corresponding to Solid Color and Fixed Base Color are selected.
  3. Click on the colored square next to the Fixed radio button to open the Color dialog window.
  4. Add the HighCloud Blue color to the Custom colors section by entering the RGB codes 0, 112, 192 into the respective Red, Green, and Blue inputs and click on the Add to Custom Colors button.
  5. While we're here, let's also add the HighCloud Brown color to the Custom colors section. Do this by first selecting the second color placeholder from the left, under the Custom colors section, then enter the RGB codes 73, 68, 41 into the Red, Green, and Blue inputs respectively. Finally, click on the Add to Custom Colors button.
  6. Select the HighCloud Blue custom color again from the Custom colors section and click on OK to close the Color dialog window.
  7. Click on OK to close the Color Area dialog window as well.

Now that we've changed the Background Color option for the Inactive Caption section, we can repeat the same process to set the Text Color option of the Inactive caption section to white. Once this is done, we've done our fair share of clicking. Fortunately, we can take a different time-saving approach for changing the Background Color option of the Active Caption section:

  1. Right-click on the Background Color option in the Inactive Caption section and select Copy.
  2. Right-click on the Background Color option in the Active Caption section and select Paste All.
  3. Repeat the same process for the Text Color option in the Active Caption section.

Note

Note that the last copied color remains on QlikView's clipboard even when other objects or text are subsequently copied.

The following screenshot shows the Inactive Caption and Active Caption sections:

Changing the caption colors

We've now set the colors used by the caption bars for this particular listbox. We will first need to tweak a few other settings before applying this style to every object caption in our document.

The Color Area and Color dialog windows

The Color Area and Color dialog windows that we've just worked with are used everywhere throughout QlikView to set the color formatting of a variety of object components.

Besides the static, solid color that we used, it is also possible to use gradients of one or two colors. Furthermore, the colors used do not always need to be fixed, they can be based on a dynamic calculation as well. A use case for this is to show a red color when a certain value is below target, and a green one when it is above the target. Calculated colors are set by using an expression with QlikView's color functions, examples of which are Red(), LightGreen(), Yellow(), and so on. In addition to these standard, pre-defined colors, any custom color can be represented using the RGB() function.

The following screenshot shows the Color Area dialog window:

The Color Area and Color dialog windows

Note that the gradient used in the previous image is an example only, it is inadvisable to use these types of candy-colored gradients in your documents.

Setting the caption font

At 10 points, the default caption font in QlikView is quite big. Let's change the caption font by following these steps:

  1. From the Properties dialog window of the Carrier's Operating Region listbox, click the title's Font button on the Caption tab.
  2. Set the Size to 9 in the Font Dialog. The font name and font style will be kept as default (Tahoma, Bold).
  3. Click on OK to apply the changes and close the window.

Setting the content font

Besides setting the caption font, we will also change the font used to display the listbox values. To do this, follow these steps:

  1. Right-click on the Carrier's Operating Region listbox and select Properties….
  2. Navigate to the Font tab.
  3. Change the font Size to 9.
  4. Click on OK to close the Properties window.

Setting the global font

An interesting feature in the Font Dialog wizard is the option to set a global Default Font option, found in the lower-left corner of the Font Dialog. By selecting either List Boxes, Chart, etc. or Text Objects/Buttons under Default Font, we can apply the currently selected font to all new objects of the selected class.

The Font Dialog window is shown in the following screenshot:

Setting the global font

This setting is available from both the caption's font dialog and the content's font dialog.

Propagating the object appearance

By following the previously described procedures, we have set the appearance for a single listbox. To apply the same configuration to all of the remaining listboxes, right-click on the one we already configured, select Properties… from the context menu, and go to the Layout tab.

At the upper-right corner of the dialog window you will see an Apply to… button. Click on it and the Caption and Border Properties dialog window will appear. Make sure to mark the following options:

  1. The Apply properties to… checkbox should be enabled.
  2. Select the Objects in this document and All object types radio buttons.
  3. Mark the Set as default for new objects in this document checkbox.
    Propagating the object appearance
  4. Click on OK on the two remaining dialog boxes to apply the changes.

Setting the default Sheet Object Style

The captions, as we've styled them now, still have a very basic look. As we noted at the start of this chapter, having a clean, basic style is not necessarily a bad thing, and in many cases is preferred. For now, however, we'll make our presentation a little bit flashier by setting another default Sheet Object Style, using the following steps:

  1. Open the Document Properties dialog by selecting Settings | Document Properties or by pressing Ctrl + Alt + D.
  2. Make sure the General tab is active.
  3. Set the Styling Mode option to Advanced.
  4. Set the Sheet Object Style option to Glass.
  5. Click on OK to apply the settings.

The object captions now have a glass-like appearance and rounded corners. The Advanced styling mode allows us to make additional changes to an object's style, such as setting rounded corners.

There are several pre-defined object styles available through the Sheet Object Style menu. The following screenshot shows how each available combination of Styling Mode and Sheet Object Style looks:

Setting the default Sheet Object Style

Hiding captions

Because of the data in them, some of the listboxes, such as Year, Quarter, and Month, do not really need captions. We can hide these captions by right-clicking on the listbox, selecting Properties…, and unmarking the Show Caption checkbox on the Caption tab.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset