Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I Need your help, Please consider this is just example
I have two filter Pane "TYPE A" and "TYPE B" for Fiscal Year(Financial Year), e.g FY-16, FY-17, FY-18, FY-19. (Here Fiscal Year is drill down)
"TYPE A" and "TYPE B" both are independent so applied alternate state "Group1" and "Group2" respectively.
Now I have created Line chart for the Number of Customer over the Fiscal Year.
But Line Chart should work on both filter pane "TYPE A" and "TYPE B"
Line Chat :
Dimension :- Fiscal Year Drill Down
Measure :- Count(CUSTOMERKEY)
Tried with :-
Count({Group1}{Group2}CUSTOMERKEY) , But here Group2 is applied only
For more Information please find below Image
Have a look at the following Design Blog posts:
https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
If those are not what you need, you can use the following link to search further:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett