Filter a pivot table

[#1]

Hi everyone

I'm relatively new to QV, I need help with the following please:

I have a pivot table with a set of dimensions and expressions. One of the expressions will retrun sum of sales for the the list of products. i want to exclude products where sales = 0

So if the value of the expression = Zero, the whole row should not appear in the pivot table. I tried using the "Supress Zero-values" under the presentation tab for the selected expression but it's not working.

Kindly assist

[#2]

Hi,

You can write in the backend in the specific table from where you are taking sales value.Where sales<>0.I think this will help you out.

regards,

Ravi

[#3]

Thanks but John helped me in the following thread

http://community.qlik.com/forums/t/29134.aspx