topic Re: Set Analysis Help - Ignoring Values in QlikView

Set Analysis Help - Ignoring Values

datagrrl — Thu, 18 May 2017 19:48:53 GMT

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.

Re: Set Analysis Help - Ignoring Values

Anonymous — Thu, 18 May 2017 20:20:50 GMT

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))

Re: Set Analysis Help - Ignoring Values

datagrrl — Thu, 18 May 2017 20:46:01 GMT

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.

Re: Set Analysis Help - Ignoring Values

Anonymous — Thu, 18 May 2017 20:49:10 GMT

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

Qlik Community Tip: Marking Replies as Correct or Helpful