Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

On the front end, you can do like this:

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

rittermd
Master
Master

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
Author

Image.PNG

Not applicable
Author

The undefined had the value but its field is not defined