Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Suppress 0's in Pivot Table

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? 12-4-2014 5-58-59 PM.png

Thank you

Z

4 Replies
Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Anonymous
Not applicable
Author

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