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: 
vyacheslavg
Contributor III
Contributor III

Simple question about missing values

Hi,

it should be very simple, but I still can't figure this out.

Please help

There are two tables

 

Id
1
2

3

  

IdColor
1green
2blue
3

For Id 3 color is missing/not available. Not zero but rather null (nothing).

Qliksense is absolutely correct, that color value for Id=3 is missing.

The question is how to sort or find all values, for which Color is "missing"?

There is no search or sorting for missing/null values.

Thanks!

Qlik-screenshot.png

1 Solution

Accepted Solutions
sunny_talwar

I guess create a flag field

LOAD Id,

          Color,

          If(Len(Trim(Color)) = 0, 'Null', 'Not-Null') as Flag

FROM ....;

Now you can select Null in Flag field to see all those Ids where Color is null

View solution in original post

3 Replies
sunny_talwar

I guess create a flag field

LOAD Id,

          Color,

          If(Len(Trim(Color)) = 0, 'Null', 'Not-Null') as Flag

FROM ....;

Now you can select Null in Flag field to see all those Ids where Color is null

dsharmaqv
Creator III
Creator III

Hi

you can write a condition for null/missing values to populate "Not available" etc. Once you do that you should be able to search it.

Mark as correct if it resolves your query

vyacheslavg
Contributor III
Contributor III
Author

thanks, so helpful!

I do this a lot in Excel, but here I could not figure out myself.

Qlik-screenshot-1.png