topic Filter condition in calculated dimension in QlikView

Filter condition in calculated dimension

Wed, 25 Nov 2020 16:16:04 GMT

I have a dimension 'Country Name'. I want to find 'Top 10' countries based on Revenue. So, in calculated dimension, I used:

if(aggr(rank(sum(Revenue)),[Country Name])<=10,[Country Name])

Problem statement:

My new requirement is, I don't want to consider some countries while I find top 10 countries. Let us say, I want to exclude COUNTRY_1 in calculated dimension.

I used :

if(aggr(rank(sum(Population)),

if(([Country Name])<>'COUNTRY_1',[Country Name])

)<=10,[Country Name])

But this is not working. Can you please help?

Re: Filter condition in calculated dimension

PrashantSangle — Thu, 30 Jun 2016 10:23:15 GMT

hi,

try like

if(not wildmatch([Country Name],'Country_1') and aggr(rank(sum(Revenue)),[Country Name])<=10,[Country Name])

Regards

Re: Filter condition in calculated dimension

PrashantSangle — Thu, 30 Jun 2016 10:29:23 GMT

or you can try below expression also

if(aggr(rank(sum({<[Country Name]-={"Country_1"}>}Revenue)),[Country Name])<=10,[Country Name])

Regards,

Re: Filter condition in calculated dimension

Thu, 30 Jun 2016 11:50:58 GMT

That was right under my nose...and I missed it.

Thank you!