Alternate state for the Different Pane with same drill down and Line Chart

[vaibhavb]

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

 

[Brett_Bleess]

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