Discussion Board for collaboration related to QlikView App Development.
Is there a way to show only the rows where the value of the first Expression is > 0?
I would only see the yellow rows in my Pivot table?
If you have more than one column then you may be write this
if (Column(1)> 0 , Sum(sales) , Null())
Please share some sample app
View solution in original post
For each expression you have to use
If(Aantal >0, YourExpression)
this works. And then in the Presentation tab Suppress Zero-Values.