Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
erric3210
Creator
Creator

Add restriction on 1 field which only filter data on one sheet and not on other sheets

Hi Community,

I've 2 sheets and they both have same 4 filters in it and different charts:

1) Year 2) Product 3) Category 4) Zone

Now, the requirement is:

When user clicks on Year filter in Sheet 2 then the data should filter out

in only Sheet 2 and not in Sheet 1 but if some one clicks on 

Product, Category or Zone filters in Sheet 2 and

Sheet 1 then the data should filter in both sheets.

 

I'm tying to use Set Analysis in it but it is giving wrong result.

See my approach:

Sum({[Alternate State1]<Area={'North'},Product=$::Product, Category=$::Category, Zone =$::Zone>}Amount)

 

Need everyone's expert help in this.

Regards,

Eric

1 Reply
simsa
Contributor III
Contributor III

You can give sheet action to achieve this:

simsa_0-1688763336430.png