strange behaviour

[qlikviewwizard]

Hi All,

I want not to show the empty and zero values from the chart.

I checked suppress zero values and suppress null values. But it is not working. Version is 11.0 SR2 64bit

Please help me.

[tamilarasu]

Hi Arjun,

I could not see any null/blank values in your chart.

[sunny_talwar]

I don't see it either

Can you post a screenshot of what you are seeing?

[qlikviewwizard]

[jagan]

Hi,

Check whether you have floating point numbers like 0.00054.  If you have like this Use Floor()/Ceil()/Round().

Regards,

Jagan.

[jagan]

Note: 0 <> 0.0000345  or any other number.

Regards,

Jagan.

[jagan · Accepted solution]

Try this expressions

if(Floor(sum(COMM)) <>0 , sum(COMM))

OR

if(Round(sum(COMM)) <>0 , sum(COMM))

Regards,

jagan.