Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Null handling

Hi guys

I have Category field in my Dashboard.

There is missing or null values as well in the column. Requirement is to define null values or missing values to ' NA' Category. I have used below expression for this in my script while loading Category field.

If(Len(Category)=0 OR Category='','NA', Category) as Category.

But still I could see blank values in the Category legend of my chart. Could you please help me in this.

2 Replies
satishkurra
Specialist II
Specialist II

Try this for handling and showing blank values as NA in chart

=if(len(trim(Category))=0,'NA',Category)

PradeepReddy
Specialist II
Specialist II

you can also try this in script...

SET  NULLVALUE ='NA';

NULLASVLUE  Category;

Load Field1, Field2, Category from File;