Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
vyacheslavg
New 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

Re: Simple question about missing values

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

4 Replies

Re: Simple question about missing values

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

Re: Simple question about missing values

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
New Contributor III

Re: Simple question about missing values

thanks, so helpful!

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

Qlik-screenshot-1.png

agrimroquette
Valued Contributor

Re: Simple question about missing values

LOAD Id,

Color,

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


FROM(Destination)


write it after your main script

Community Browser