It´s possible to use more than one alternate state in a single chart?

[#1]

Hello everyone,

I am developing a dashboard which displays the Key Performance Indicators (KPIs) by area of the company.

Most of the charts of my sheet are using an open trigger to show data from the current month when user open the dashboard. As i don´t want that all my charts starts with data of the current month, i set an alternate state called "CurrentMonth" to that open trigger.

In the end of my dashboard i have a bar chart which displays the KPIs by month, and it should display the first KPI value of the field, so i am also using an open trigger, to set this condition to that bar chart. As i don´t want this rule to the other objects of my sheet, i added an alternate state called "FirstKPI" to this open trigger as well.

The problem is that i lost the relationships between my objects and the bar chart in the end of my dashboard because of the 2 alternate states that i create. So, i tried to apply more than one alternate state to my bar chart in the end of the sheet, but i think it is not possible.

Anyone could help me to solve this?

Thanks

[Oleg_Troyansky]

Hi Rodrigo,

You have a number of other options, primarily with the use of Set Analysis.

It's common to "pre-define" a certain time frame for the Dashboard sheet (as opposed to the analytical and reporting sheets), and the best way of doing that is through the use of Set Analysis. This way, you don't have to rely on any triggers or fiddle with changing Selections behind the user's back. Within Set Analysis, it's best to use calendar flags that are calculated in the data set.

For example:

sum({<_CurrentMonth_Flag={1}>} Sales)

When you use Set Analysis, you can have some chart expressions showing Current Month (or YTD) numbers, while other expressions and/or charts can be showing other time frames.

Back to Alternate States question:

- A single chart can only be assigned to a single Alternate State.

- Chart expressions can be assigned to other Alternate States using Set Analysis with the Alternate State name used as a Set Identifier. For example:

sum ({FirstKPI<modifiers>} Sales)

Check out my new book QlikView Your Business. In the book, I'm teaching in detail how to use Set Analysis and how to use Alternate States for a variety of analytical needs.

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business: An expert guide to Business Discovery with QlikView an...