Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Hide row with condition


Is it possible to hide a row in a table when a value of one column is superior to another?

I created an app to forecast the evolution of the space used in few drives.
I want to hide all rows where the space used is less than the space max.

1 Reply
MVP & Luminary
MVP & Luminary

You can hide rows per se. But you could not generate the rows using a calculated dimension, something like:

=Aggr(if(sum(used) => sum(spacemax), DriveName), DriveName)