Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two charts with regions on it. When I make selections of 1 region on a chart, the other chart should show the regions excluding the region which is selected on the first chart. Ex- There are two charts with regions N,W,E,S -- If I make selection on W region on that chart, the other chart should be modified to show the region N,E,S. Can we address this scenario using Alternate States?
I assume that your calculation is something like SUM(Amount) so you will need to adjust my suggestion to your data model.
Try this in table 2 where you want the excluded regions.
SUM({< Region=E(Region) >}Amount)
Sujit, just to give you a little more info regarding Vegar's idea, here is a link to a Design Blog post that may provide some further explanation for you:
https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704
If Vegar's post did the trick, be sure to use the Accept as Solution button to give him credit for the help and let others know that was the correct solution.
Regards,
Brett