Set Analysis Help - Ignoring Values

[datagrrl]

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.

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:

My simple expression for chart 2:

Sum({$<Country= > }Measure)

This is a mock up of the data.

Any assistance is appreciated.

[Anonymous · Accepted solution]

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]

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]

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

Qlik Community Tip: Marking Replies as Correct or Helpful