Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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
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

MVP
MVP

For each expression you have to use

If(Aantal >0, YourExpression)

Partner
Partner

Thanks,

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

Regards,

Kris

Master III
Master III

Good...