topic Re: Suppress 0's in Pivot Table in QlikView

Suppress 0's in Pivot Table

Thu, 04 Dec 2014 23:02:00 GMT

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

Re: Suppress 0's in Pivot Table

Fri, 05 Dec 2014 00:37:09 GMT

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

Re: Suppress 0's in Pivot Table

Fri, 05 Dec 2014 00:40:44 GMT

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

Re: Suppress 0's in Pivot Table

Fri, 05 Dec 2014 00:42:57 GMT

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

Re: Suppress 0's in Pivot Table

Anonymous — Fri, 05 Dec 2014 02:03:21 GMT

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