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) |
