Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
datagrrl
Creator III
Creator III

Set Analysis Help - Ignoring Values

Hello-

This is a pretty basic set analysis question.

I have countries and zones. When someone selects a country in chart one, I want to see numbers for all countries in that zone on chart 2.

AllData.PNG

They will not have selected the zone in any other filter, so it isn't really a "Current Selection"

I accomplished the desired outcome by using a trigger on the country field (Zone=Zone), but I was wondering if there is a better way to do this:

Canada.PNG

My simple expression for chart 2:

Sum({$<Country= > }Measure)

This is a mock up of the data.

Any assistance is appreciated.

1 Solution

Accepted Solutions
Anonymous
Not applicable

I'm not entirely sure what you're saying.......

But maybe create a variable of

vZone=max(Zone)

and your expression is

=if(getselectedcount(Country)=1,

      Sum({$<Zone={'$(vZone)'},Country=> }Measure),

          Sum({$<Country= > }Measure))

View solution in original post

3 Replies
Anonymous
Not applicable

I'm not entirely sure what you're saying.......

But maybe create a variable of

vZone=max(Zone)

and your expression is

=if(getselectedcount(Country)=1,

      Sum({$<Zone={'$(vZone)'},Country=> }Measure),

          Sum({$<Country= > }Measure))

datagrrl
Creator III
Creator III
Author

You must have understood what I was asking for, because it worked. I haven't been doing a ton of development lately, so this wasn't simple for me and I was having an issue figuring out what terms to search for.

Thanks for your help.

Anonymous
Not applicable

Glad it worked.  Can you mark my response as the answer then?

Qlik Community Tip: Marking Replies as Correct or Helpful