topic Re: Exclude selections on alternate state in QlikView

Exclude selections on alternate state

sujit_nath — Sat, 16 Nov 2024 02:18:42 GMT

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?

Re: Exclude selections on alternate state

Vegar — Fri, 04 Oct 2019 03:58:20 GMT

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)

Re: Exclude selections on alternate state

Brett_Bleess — Thu, 10 Oct 2019 17:47:35 GMT

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