Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
it should be very simple, but I still can't figure this out.
Please help
There are two tables
Id |
1 |
2 |
3 |
Id | Color |
1 | green |
2 | blue |
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!
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
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
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
thanks, so helpful!
I do this a lot in Excel, but here I could not figure out myself.