Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted
MVP
MVP

For each expression you have to use

If(Aantal >0, YourExpression)

Highlighted
Partner
Partner

Thanks,

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

Regards,

Kris

Highlighted
Master III
Master III

Good...