topic Re: Simple question about missing values in App Development

Simple question about missing values

vyacheslavg — Fri, 13 Jan 2017 10:42:43 GMT

Hi,

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

Please help

There are two tables

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!

sunny_talwar — Fri, 13 Jan 2017 10:44:30 GMT

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 — Fri, 13 Jan 2017 10:47:15 GMT

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 — Fri, 13 Jan 2017 10:50:53 GMT

thanks, so helpful!

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