topic Re: How to exclude certain dimension values in QlikView

How to exclude certain dimension values

Mon, 20 Oct 2014 20:00:37 GMT

Dimension: StoreName

Expression: sum(Revenue)

I am trying to exclude the dimension to include only stores that have >100 customer accounts associated with it. How do I go about doing this?

I tried

if(count(DISTINCT Account)>100, StoreName)

but that doesn't seem to work. Should I be using an aggr() function? Set analysis?

Thank you!

Re: How to exclude certain dimension values

maxgro — Mon, 20 Oct 2014 20:07:52 GMT

sum({$<StoreName={"=count(distinct Account)>100"}>} Revenue)

Re: How to exclude certain dimension values

Mon, 20 Oct 2014 20:10:02 GMT

Thanks, Massimo!

I would use that as the expression, but is there any way I could exclude those dimension values using a calculated dimension rather than doing it in the expression?

Re: How to exclude certain dimension values

maxgro — Mon, 20 Oct 2014 20:19:21 GMT

=if(aggr(count(DISTINCT Account), StoreName)>100, StoreName)

Re: How to exclude certain dimension values

Mon, 20 Oct 2014 21:29:29 GMT

That worked perfectly. Thank you!