Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Removing row based on expression

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

1 Solution

Accepted Solutions

Re: Removing row based on expression

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)

View solution in original post

7 Replies
balrajahlawat
Esteemed Contributor

Re: Removing row based on expression

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

Hi Maarten,

You can use suppress null values option in presentation tab.

Capture.PNG

MVP
MVP

Re: Removing row based on expression

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

Not applicable

Re: Removing row based on expression

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.

MVP
MVP

Re: Removing row based on expression

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

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)

View solution in original post

Not applicable

Re: Removing row based on expression

Unfortunately, this was it. Thank you all anyways!