topic Filter a pivot table in QlikView

Filter a pivot table

Mon, 07 Feb 2011 11:00:50 GMT

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

Filter a pivot table

Mon, 07 Feb 2011 13:23:42 GMT

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

Filter a pivot table

Mon, 07 Feb 2011 13:40:00 GMT

Thanks but John helped me in the following thread

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