Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ljames88
Contributor
Contributor

Filter out pivot results

I created a pivot table expression which works well, however I only want to see totals that do not equal zero, or perhaps = 100, how can I do that so my pivot table only shows those types of results.  See below.  I have Total Bill as a column, but I only want to see the data when the Total Bill is not = 0

Capture.PNG

1 Reply
sunny_talwar

May be all you need to do is use an if statement for all your other expression to check if [Total Bill] > 0

If([Total Bill] > 0, Sum(QUANTITY))

If([Total Bill] > 0, ....)

....

And then once you do that, make sure you have checked 'Suppress Zero Values' on the presentation tab.