topic Problem suppress zero-values in QlikView

Problem suppress zero-values

Thu, 12 Nov 2015 12:47:43 GMT

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

Re: Problem suppress zero-values

sunny_talwar — Thu, 12 Nov 2015 13:07:23 GMT

What happens when you change the expression to this -> If(Len(Trim(Column_Name)) = 0, ‘Data not identified’, Column_Name)

Re: Problem suppress zero-values

Chanty4u — Thu, 12 Nov 2015 13:13:49 GMT

try this

SUM({<fieldname={'=Len(Trim(dimension))=0'},field={'fieldname'}>}dimen)

Re: Problem suppress zero-values

Thu, 12 Nov 2015 21:25:06 GMT

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.