topic Re: strange behaviour in QlikView

strange behaviour

qlikviewwizard — Wed, 28 Oct 2015 02:08:00 GMT

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 — Wed, 28 Oct 2015 02:17:50 GMT

Hi Arjun,

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

sunny_talwar — Wed, 28 Oct 2015 02:34:07 GMT

I don't see it either

Can you post a screenshot of what you are seeing?

qlikviewwizard — Wed, 28 Oct 2015 02:38:53 GMT

jagan — Wed, 28 Oct 2015 03:58:23 GMT

Hi,

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

Regards,

Jagan.

jagan — Wed, 28 Oct 2015 03:59:24 GMT

Note: 0 <> 0.0000345 or any other number.

Regards,

Jagan.

jagan — Wed, 28 Oct 2015 04:00:17 GMT

Try this expressions

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

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

Regards,

jagan.