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

Missing, Blank and Null Values

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

3 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
nagaiank
Specialist III
Specialist III

I think

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

will return 12

Not applicable
Author

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

All working now

Thanks

Keith