Currently, our QlikView document contains the following listboxes in the Dash board sheet:
Let's see how we can add listboxes and change their properties.
Lets add another listbox representing the Carrier Name field by right-clicking on the worksheet and selecting Properties. (or by pressing Ctrl + Alt + S, which is the shortcut for the Settings | Sheet Properties menu command). Next, open the Fields tab, locate the Carrier Name field under the Available Fields list, and click on Add >to add it as a new listbox.
In a moment we will discuss the positioning of the objects we are adding, but for now let's add another listbox, this time using a different method:
The List Box Properties dialog
Besides the default settings, there are quite a few other options that can be set for listboxes. In this section, we will review the most common of these options. Right-click on any listbox and select Properties, to open the List Box Properties dialog window.
While the customization of the listboxes' appearance is quite flexible, one of the options that cannot be changed, at least not out-of-the-box, are the colors used to identify selections .Green always means selected, while white and gray mean associated and excluded values respectively.
The General tab
As the name implies, the General tab contains general options for the listbox. Notable options are:
The Expressions tab
The Expressions tab lets us add calculations and mini charts into listboxes, for example, adding the number of departures to the Carrier Name listbox by using the expression Sum([# Departures Performed]). The following screenshot shows the Carrier Name listbox with an expression in place:
The Sort tab
The Sort tab is commonly found across many objects. It offers the option to order the data using any of the following sort orders, outlined in descending order of priority:
The Presentation tab
The Presentation tab lets us change some of the presentation aspects of the listbox. Some of the important options are as follows:
The Number tab
Like the Sort tab, the Number tab is used by many different objects. It allows us to control how the listbox content looks by using either predefined or custom formats. For example, if we always want numbers to be displayed with two decimals, we can follow these steps:
By clicking on the Change Document Format button, a dialog is opened that lets us set the default number format for every individual field at the document level. This means we will only need to specify the format once, and it will be used everywhere within our document. This option is also available via the Document Properties dialog window (Settings | Document Properties | Number).
The Font tab
The Font tab is also a common one, and its purpose is very straightforward. We already worked with these properties earlier in the chapter while changing the caption font.
The Layout tab
Just as with the others, the Layout tab is also one that is used for nearly every object in QlikView. As the name suggests, it allows us to set various layout options.
The different properties available through this tab are directly affected by the document styling mode (Simplified or Advanced). The Advanced styling mode adds more options for styling borders and enables the possibility for rounded corners to be set.
Since the Advanced styling mode is more comprehensive, this I section assumes the Advanced styling mode is turned on.
Important options on this tab are as follows:
The Caption tab
The Caption tab is also a common tab across all QlikView objects. We used it before to set the listbox caption colors and fonts, but it contains a few other interesting options:
This concludes the side-step into the various listbox properties. Don't worry if you didn't memorize all of them at first, we'll encounter them often enough in the rest of the book.
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.