Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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 :
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?
Any idea?