Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning!
I have a database with some Null values. I worked on this data to show when values is Null “Data not identified”. To make this result I used function IF(IsNull(Column_Name), ‘Data not identified’, Column_Name) on script. It worked.
The problem is when I use this column as a dimension on chart.
If option suppress zero-values is checked not appear underline as a value, but if I unchecked suppress zero-values appear underline as a value.
I don`t know what`s happening, because there isn`t null values on my database Qlikview.
Example:
Option suppress zero-values is checked
Option suppress zero-values is unchecked
Thanks
Looks like there are null values in your dimension table. may be they got introduced on table joining ? did you check the information density of this field on your datamodel viewer. I would rather have the data fixed than patching it on the charts.
What happens when you change the expression to this -> If(Len(Trim(Column_Name)) = 0, ‘Data not identified’, Column_Name)
try this
SUM({<fieldname={'=Len(Trim(dimension))=0'},field={'fieldname'}>}dimen)
Looks like there are null values in your dimension table. may be they got introduced on table joining ? did you check the information density of this field on your datamodel viewer. I would rather have the data fixed than patching it on the charts.