topic Re: Comparing two selection - Alternate States? in QlikView

Comparing two selection - Alternate States?

brunolelli87 — Mon, 19 Apr 2021 20:54:58 GMT

Hello guys,

With the following I chart I can see the number of flights per airline per day.

The dimensions are:

- DASI //Date format - NCIA //Airlines name

The expressions is:

count({<DASI=>} DISTINCT KEYI) //KEYI is my Key field

Now, I would like to create another chart with just two bars in order to compare those Dates or Periods selected on Group1 and Group2. So, I'm expecting something like this:

I tried to use Alternate States with no success... how can I do that? Any ideas?

Please, find attached a sample file, but once I'm using Qlikview Personal Edition I won't be able to open any file!

Thanks guys,

Re: Comparing two selection - Alternate States?

QFabian — Mon, 19 Apr 2021 23:44:32 GMT

Hi @brunolelli87 , here a few steps to do what you want :

1.- Create the Alternate States

2.- Create new list boxes for DASI and their alternate states:

3.- modify your expressions to consider the alternate state:

4.- Test :

Re: Comparing two selection - Alternate States?

brunolelli87 — Mon, 19 Apr 2021 23:55:11 GMT

Hello @QFabian, thanks for your kindly response.

I've already done eveything as you kindly mentioned above... but I could not create the stacked bar chart and, even worst, if the user select 2 days on Group1 and 2 days on Group2, he would ended up with 4 "items" as dimension, and I would like to have just two.

As you can see on my example above, the user selected 7 days on Group1 and 7 days on Group2, and the expected result is 2 stacked bars (and not 14).

I believe I need the sum of counts, per airline, you know 😊

Can you help me doing that?

Re: Comparing two selection - Alternate States?

brunolelli87 — Wed, 21 Apr 2021 16:23:57 GMT

Any idea?