Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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...