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:
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:
1. 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:
Related Page: Synthetic Keys In Qlikview
2. 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:
3. 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.
4. 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.
Related Page: Table Viewer In QlikView
*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.
Get Updates on Tech posts, Interview & Certification questions and training schedules