Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Similarly to this https://community.qlik.com/t5/New-to-Qlik-Analytics/list-of-objects-in-Feld-that-have-Null-as-Other-... post, I have a table that I want to use as a mapping. The data source may contain new codes for metabolites that I need to detect and then manually add to my mapping table. I therefore need a sheet with a table of those new codes as an overview.
Metabolite | Drug |
11-nor-9-carboxy-D9-THC (THC metabolite) | Cannabis |
6-monoacetylmorphine (heroine metabolite) | - |
Benzoylecgonine (cocaine metabolite) | Cocaine |
Inspired by the post mentioned above, I tried to apply a set expression like
={1<Metabolite={"=IsNull(Drug)"}>}Metabolite
but my table still shows all values, even when showing only the dimension above. The result should be
Metabolite |
6-monoacetylmorphine (heroine metabolite) |
Seems to work fine when placed into Only():