Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted

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

Highlighted
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

Highlighted
Contributor III
Contributor III

thanks, so helpful!

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

Qlik-screenshot-1.png