Set Analysis

[sumitratnani]

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.

[Anonymous]

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

[sunny_talwar]

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

[kaushiknsolanki]

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