Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jchang_snwl
Not applicable

Chart suppress NULL but show zero

Hello there,

How to have a chart show zero values and suppress null?

Here is what I have now if I uncheck Presentation -> suppress zero-values

Some dimensions have null value but other have zero.

How to truncate those dimensions with NULL and keep those with a value which could be zero or other value.

Help is very appreciated.

Thanks,

Josh

suppressZero.PNG

1 Reply
rahulpawarb
Not applicable

Re: Chart suppress NULL but show zero

Hello Josh,

As a workaround, you can use SET NullInterpret = '-1'; statement in script and filter those records with -1 value.

Regards!

Rahul