Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sujit_nath
Creator III
Creator III

Exclude selections on alternate state

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?

Labels (2)
2 Replies
Vegar
Partner
Partner

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)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Brett_Bleess
Support (Former)
Support (Former)

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

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.