Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
vaibhavb
Contributor
Contributor

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

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

 

 1.png2.png

 

1 Reply
Brett_Bleess
Employee
Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.