topic Re: Filter out pivot results in QlikView

Filter out pivot results

ljames88 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Filter out pivot results

sunny_talwar — Wed, 21 Sep 2016 00:09:58 GMT

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.