Discussion Board for collaboration on QlikView Scripting.
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.
As a workaround, you can use SET NullInterpret = '-1'; statement in script and filter those records with -1 value.