topic Re: Removing row based on expression in QlikView

Removing row based on expression

Fri, 20 Nov 2020 18:02:30 GMT

Hi all,

I have an aggregated expression to determine the number of stores our clients have. Now I want to filter this, that all store-counts < 5 are not visible. But instead of showing - or 0 or null, I want the row to disappear. How can I do this?

Kind Regards,
Maarten

Re: Removing row based on expression

Anonymous — Mon, 16 Nov 2015 10:21:50 GMT

try like:

=if(aggr(count(StoreID), Client)>=5, Client).......

it will give you only those Clients whose stores are equal or more than 5

Re: Removing row based on expression

tamilarasu — Mon, 16 Nov 2015 10:25:06 GMT

Hi Maarten,

You can use suppress null values option in presentation tab.

Re: Removing row based on expression

tresB — Mon, 16 Nov 2015 10:26:18 GMT

Check 'Supress When Value is Null' in the dimension tab.

Re: Removing row based on expression

Mon, 16 Nov 2015 10:27:54 GMT

Yeah I know, but it isn't working, since I have more expressions running about.... I was hoping for a simple solution instead of giving about 15 expressions an if(storecount >5), ... calculation.

Re: Removing row based on expression

tresB — Mon, 16 Nov 2015 10:35:35 GMT

If you use the condition in the dimension (use calculated dimension), it should work. Could you post a sample qvw?

Re: Removing row based on expression

tamilarasu — Mon, 16 Nov 2015 10:39:33 GMT

Then you have to add the below line for all your 15 expressions. So that all the expressions will show null for the specific dimension and chart will not display the row.

If(storecount>5, Expression1)

Re: Removing row based on expression

Mon, 16 Nov 2015 10:49:44 GMT

Unfortunately, this was it. Thank you all anyways!