topic Re: Null handling in QlikView

Null handling

Mon, 15 Feb 2016 10:22:09 GMT

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.

Re: Null handling

satishkurra — Mon, 15 Feb 2016 16:18:16 GMT

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

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

Re: Null handling

PradeepReddy — Mon, 15 Feb 2016 16:21:56 GMT

you can also try this in script...

SET NULLVALUE ='NA';

NULLASVLUE Category;

Load Field1, Field2, Category from File;