How to use Visual Cues and Alternate States in QlikView?
Using Visual Cues
Visual cues are a handy (and perhaps simpler) way to create visual color alerts in tables. To create a visual cue, follow these steps:
- Holding Ctrl pressed, click-and-drag the chart you just made to another area of the sheet. This will duplicate the object (and is a very useful trick). In the dimensions tab, delete the expression we used to set the background color.
- In the upper field of the visual cues tab, enter Avg (total cases). Set the text to black and background to light blue.
- In the lower field, set the text to black and the background as light red. Check the bold box to change the font to bold.
- In the presentation tab, set the totals to appear on the last row, and in the expression tab, set the totals to appear as expression total on the last row. Select the use label check box and enter total cases. Click. It appears very much like the previous chart, except for the font and totals row.
Using Alternate States
By default users selections in QlikView are stored in ‘$’. Alternate states make it possible to create additional selection states beside $.
Alternate states can help business users compare two different dimensions (whether they are related or unrelated). It performs comparative analysis between sets of multiple data items. The developer creates multiple states within a Qlikview document and applies them to specific objects. Alternate state functionality is not accessible in the load script.
An analysis like this can be quite useful, particularly when combined with set analysis (described in the next section), because state settings can be used in an expression in conjunction with a set modifier. Alternate states refer to setting a state of a sheet or object, and sheets and objects with that assigned state will respond to each other. Objects of different assigned states will be disconnected from one another.
Follow these steps to set up alternate states:
- Enable the alternate states feature for the application in the document properties dialog, via the alternate states button in the general tab, click on the add button to add the name of an alternate state, such as alternate state1, state1, or any description, as shown in the following diagram:
- Now that alternate states have been added to the document properties, the alternate states feature is activated. This adds a new alternate state drop-down list to the object properties tab, as shown in the following diagram:
- You can use alternate states to assign an alternate state to a chart and list box any objects assigned to the same alternate state will be linked and associated. This is usually used with a list box that controls the function of a chart-in this case, both the list box and the chart will have the same assigned alternate state name.
- You may wish to have two identical list boxes and two identical charts, with each list box and chart pairing having its own alternate state assignment. This allows the business users the ability to dynamically compare two separate dimensions (two different products, sales persons, regions) against some measure.
Key points to remember about alternate states:
*alternate state sheets and objects are disconnected from other selections that are made elsewhere, unless those selections were made on an object with the same alternate state assignment.
*this disconnected from the entire document does limit alternate state functionality. It is more powerful when combined with set analysis.
*the document, and any unassigned sheets and objects, always have an alternate state assignment of default.
*objects can also inherit an alternate state of a parent object. For a sheet object, this can be the alternate state setting of a container, or from a sheet.
Enroll for Live Instructor Led Online QlikView Training