Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Arjunarao
Honored Contributor II

strange behaviour

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: strange behaviour

Try this expressions

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

OR

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


Regards,

jagan.

6 Replies

Re: strange behaviour

Hi Arjun,

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

Capture.PNG

2.PNG

Re: strange behaviour

I don't see it either

Capture.PNG

Can you post a screenshot of what you are seeing?

Arjunarao
Honored Contributor II

Re: strange behaviour

Capture.PNG

MVP & Luminary
MVP & Luminary

Re: strange behaviour

Hi,

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

Regards,

Jagan.

MVP & Luminary
MVP & Luminary

Re: strange behaviour

Note: 0 <> 0.0000345  or any other number.

Regards,

Jagan.

MVP & Luminary
MVP & Luminary

Re: strange behaviour

Try this expressions

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

OR

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


Regards,

jagan.