lookup value of ID based on current selection

[ZuzJsk007]

Hi, I'm fairy new to Qlik Sense and I'm struggling with the following:

I have a Filter pane with ProductName. I would like to display ProductID in a table measure based on that selection, something like:

only(FieldValue(ProductID, FieldIndex('ProductName', GetFieldSelection(ProductName))))

(in data model, the two fields are a part of the same table)

So I would get a table like below when I select ProductName "Abc, Def" which actually have ID 1 and 2:

ProductID

1,2

Thank you very much 🙂

[MayilVahanan · Accepted solution]

HI @ZuzJsk007 

Try like below

Concat(Distinct ProductID, ',')

or

if(GetselectedCount(ProductName) > 0, Concat(Distinct ProductID, ','))

[ZuzJsk007]

The if() version works like a charm, thanks a lot!:)