Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

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


1 Reply

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.