topic Re: Set Analysis in QlikView

Set Analysis

sumitratnani — Mon, 13 Feb 2017 15:26:15 GMT

I have this kind of expression in multiple charts for Important Awards

Count({1<Award = {'Star of the Month','Spot Award','Performance Award','Quarterly Award'}>} [Award Id])

I wonder if I could keep this thing {'Star of the Month','Spot Award','Performance Award','Quarterly Award'} in some variable and use that variable in above expression so that in future if I have to change number of important Awards , I should change at one place and result should reflect in all charts.

I am not looking for getSelection kind of methods approach.

Please if one could help.

Thanks in advance.

Re: Set Analysis

Anonymous — Mon, 13 Feb 2017 16:33:56 GMT

Count({1<Award = {$(YOURVARIABLE)}>} [Award Id])

Re: Set Analysis

sunny_talwar — Mon, 13 Feb 2017 16:34:16 GMT

Sure, create a variable like this through variable overview

vAwards

'Star of the Month','Spot Award','Performance Award','Quarterly Award'

and then this

Count({1<Award = {$(vAwards)}>} [Award Id])

Re: Set Analysis

kaushiknsolanki — Mon, 13 Feb 2017 16:36:03 GMT

Hi,

The optimized way is you flag the Award in Script, like below.

LOad *, if(Wildmatch(Award,'Star of the Month','Spot Award','Performance Award','Quarterly Award'),1,0) as Flag From xyz;

Then you can use the set analysis like below.

Count({1<Flag = {1}>} [Award Id])

Regards,

Kaushik Solanki