Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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