Just as there are document-level properties, we can also set properties at the sheet- and object-level. Let's have a quick look at the Sheet Properties dialog.
Open this window by right-clicking on an empty space in the Dashboard worksheet and selecting Properties..
The following screenshot shows the Sheet Properties dialog:
As its name implies, the Sheet Properties dialog can be used to set various properties of a worksheet. Let's quickly review the available options.
On the General tab, the following properties are of interest:
We've previously worked with the Fields tab, which is an easy way to add multiple listboxes to the sheet. Simply select the required fields from the Available Fields listbox and double-click (or click Add >) to include them in Fields Displayed in Listboxes.
The Objects tab shows all of the objects that are present on the worksheet, even those that are conditionally hidden. From this tab, we can directly open the individual object's Properties... dialog or even Delete any of them. The Objects tab is shown in the following screenshot:
It's also worth noting the Calc Time and Memory columns in the Objects tab. These can be used to optimize our document by identifying which objects have the most impact on performance, or are using up a lot of memory.
The Security tab is used to set what users are allowed to do on the corresponding sheet. We are also able to propagate the security settings to all sheets if the Apply to All Sheets checkbox is marked. Additionally, when the Read Only checkbox is enabled, no selections can be made on the sheet.
Triggers are events to which QlikView can react with Actions. When used on sheets, a trigger can be set to respond to events such as activate and deactivate, meaning it will run when entering or leaving the sheet, respectively. Triggers will be discussed in more detail in Chapter More on Visual Design and User Experience.
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.