Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Valued Contributor II

Re: Null handling

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

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

pradeepreddy
Valued Contributor II

Re: Null handling

you can also try this in script...

SET  NULLVALUE ='NA';

NULLASVLUE  Category;

Load Field1, Field2, Category from File;

Community Browser