Removing row based on expression

[#1]

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

[Anonymous]

try like:

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

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

[tamilarasu]

Hi Maarten,

You can use suppress null values option in presentation tab.

[tresesco]

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

[#5]

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.

[tresesco]

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

[tamilarasu · Accepted solution]

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)

[#8]

Unfortunately, this was it. Thank you all anyways!