Suppress 0's in Pivot Table

[#1]

Hello - Can you please help me with figuring out how to suppress 0 values in a pivot table.

I am displaying top 10 products for the last 3 month. I would like to suppress or hide columns that have null values.

I tried to use the "Suppress Null Values" function but it's not working for me. What else can i do?

Thank you

Z

[#2]

Go to the "Presentation" tab and select "Suppress Zero-Values" from the bottom left.

[#3]

Thank you but i have done it before and it does not work.

[#4]

You could try using set analysis to include only values greater than 0?

[Anonymous]

Hi,

In general Qlikview will definitely suppress if all the values in the column is 0. I suspect, in you columns one of more of the rows are containing non zero values(like .0001 and rounding off to 0). check number format and allow decimals . So that you come to know which one is having non zero values.

Hope this helps.

I made a sample qvw which is automatically supressing the 0 values if all the rows are 0 in a particular column.

BR,

chinna