Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Master II
Master 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

Try this expressions

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

OR

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


Regards,

jagan.

View solution in original post

6 Replies

Hi Arjun,

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

Capture.PNG

2.PNG

I don't see it either

Capture.PNG

Can you post a screenshot of what you are seeing?

Master II
Master II

Capture.PNG

MVP & Luminary
MVP & Luminary

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

Note: 0 <> 0.0000345  or any other number.

Regards,

Jagan.

MVP & Luminary
MVP & Luminary

Try this expressions

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

OR

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


Regards,

jagan.

View solution in original post