Supress Null Values in expression of Pivot Table

[#1]

Hello,

Below is the chart I have created.

Even though all the values are null, they do not get suppressed.

My dimensions are

Region,

Country,

Remote ID,

Hiring Type (2012 Reductions and  2012 Hiring)

Classification (Attrition, etc)

My expression is a simple if(Sum(Count)=0,null(),Sum(Count)))

How can I suppress these values in the pivot table.

Thanks,

BK

[deepakk]

hi BK,

I think there is no need to check if it is zero.  You can simply write Sum(Count). Qlikview will by default take the zero values as null.

Deepak

[#3]

Hi Deepak,

I did a normal Sum(Count).

Eventhough I I have Suppress Zero checked, the zeroes dont suppress.

It is really disturbing to see so many Zeroes i the chart, so I changed them to null values.

I really dont understand why they are not being suppressed.

Thanks,

BK

[#4]

Hi Deepak,

I did a normal Sum(Count).

Eventhough I I have Suppress Zero checked, the zeroes dont suppress.

It is really disturbing to see so many Zeroes i the chart, so I changed them to null values.

I really dont understand why they are not being suppressed.

Thanks,

BK

[deepakk]

Hi BK,

Can you check if in presentation table Suppress null and suppress missing is enabled ?

Can you attach the sample file.

Deepak