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:
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:
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:
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:
Note that the last copied color remains on QlikView's clipboard I even when other objects or text are subsequently copied.
The following screenshot shows the Inactive Caption and Active Caption sections:
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:
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:
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:
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:
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:
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:
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:
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.
Qlik View Related Interview Questions
|Microstrategy Interview Questions||IBM Cognos Interview Questions|
|PL/SQL Interview Questions||MSBI Interview Questions|
|VBA For Excel Interview Questions||SAP BO Interview Questions|
|SQL Database Interview Questions||Qlik View Interview Questions|
|R Programming language Interview Questions||Pentaho Interview Questions|
|Advanced SAS Interview Questions|
Qlik View Tutorial
Seeing Is Believing
Data Modeling Best Practices
Basic Data Transformation
Set Analysis And Point In Time Reporting
Advanced Data Transformation
More On Visual Design And User Experience
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.