Discussion board where members can learn more about Qlik Sense App Development and Usage.
it should be very simple, but I still can't figure this out.
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.
Go to Solution.
I guess create a flag field
If(Len(Trim(Color)) = 0, 'Null', 'Not-Null') as Flag
Now you can select Null in Flag field to see all those Ids where Color is null
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.