Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to write name for label for a null value in the chart

I am working on Finance dashboard. I got one null value for which I want to name the label as Undefined Number. How can I do it. 

4 Replies

Re: How to write name for label for a null value in the chart

On the front end, you can do like this:

If(Len(Trim(FieldName)) = 0, 'Undefined Number', FieldName)

rittermd
Honored Contributor

Re: How to write name for label for a null value in the chart

Currently you can't do anything in the visualization itself.  What Sunny suggested should work for you if you are not doing the calculation in the chart/table itself.

Not applicable

Re: How to write name for label for a null value in the chart

Image.PNG

Not applicable

Re: How to write name for label for a null value in the chart

The undefined had the value but its field is not defined