TABLE of objects in [Field] that have Null as [Other Field]

[Gaël]

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)

[Or · Accepted solution]

Seems to work fine when placed into Only():