topic Re: Missing, Blank and Null Values in QlikView

Missing, Blank and Null Values

Fri, 21 Mar 2014 14:31:19 GMT

Hi there

I am trying to provide a count of the missing, blank and null values in the attached Customer Address table.

I have tried many on the helpful examples from the community but cant seem to get the result I expect or understand my results.

I am simply adding Expressions in the List Box widget and had sucess with count min and max values.

I am using the system value of $Fields in my expressions.

In the data I would expect a 0 return for Address Number but 12 for 'Customer Address 1' field.

Any suggestions and advice would be much appreciated.

Thanks

Keith

Gysbert_Wassenaar — Fri, 21 Mar 2014 14:37:01 GMT

You can test for nulls and empty strings with if(trim(len(MyField))=0,....

And the 'empty' values in Customer Address 1 in your excel file seem to be strings of 40 spaces.

nagaiank — Fri, 21 Mar 2014 14:38:33 GMT

I think

Sum(If(Len(Trim([Customer Address 1]))=0,1,0))

will return 12

Fri, 21 Mar 2014 14:47:06 GMT

Hi Gysbert / Nagaina - Thank you for your prompt replie and explaining the what I need.

All working now

Thanks

Keith