Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kris_vliegen
Partner
Partner

Show only rows when first expression > 0 inPivot Table

Hi all,

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?

regards,

Kris

Elka111.JPG

1 Solution

Accepted Solutions
prma7799
Master III
Master III

If you have more than one column then you may be write  this

if (Column(1)> 0 , Sum(sales) , Null())

Or

Please share some sample app

View solution in original post

4 Replies
prma7799
Master III
Master III

If you have more than one column then you may be write  this

if (Column(1)> 0 , Sum(sales) , Null())

Or

Please share some sample app

View solution in original post

MK_QSL
MVP
MVP

For each expression you have to use

If(Aantal >0, YourExpression)

kris_vliegen
Partner
Partner
Author

Thanks,

this works. And then in the Presentation tab Suppress Zero-Values.

Regards,

Kris

prma7799
Master III
Master III

Good...