link table to filter field

[#1]

Hello Everyone,

I have a filter field with a list of name and a table with some columns (another list of name and a measure that I calculate). I would like to link the 2. So, if I click on a name in the filter field, It displays some names of the table not all of the possible names.

I tried some expressions, 'if',  using the filter name but it doesn't work.

Does someone know if it is possible and how to do that ?

Regards,

Paloma

[ArnadoSandoval]

Hi Paloma,

Based on your example, and if I understand what you want to do, it seems you need a second filter on the ID column (Person table, ID column) have you tried that?

After reading your initial post, add a second filter on your "measure" column (whatever its name), the one you are calculating.

hth

[#3]

Thank you all for your answer. But it is not really what I want to do. I would like, to the main field of my table so Name, to do :

if filter field = Sweden and if ID = 1 then display Name

But I guess what I have in mind it is not possible. 

[OmarBenSalem]

Like this?

[#5]

Yes something like this but I would only have to click on Sweden (table 1) to display john (table 2) not to click on Sweden and John from table 1

[OmarBenSalem]

You only click on Sweden.

See the attached app: (first sheet)

[#7]

Thank you that's it. But my ID is not numeric, it is alphanumeric will it work the same way ? and if I want to select more than one ID ?

I tried several things like sum({<ID={"=aggr(ID={"i1","i2"},Country)"}>}Sales) and sum({<ID={"=aggr({<ID={"i1","i2"}>}ID,Country)"}>}Sales) but it doesn't work.

[#8]

Hello,

I think I may have found a solution using qsVariable.

my expression is : =Pick(Match($(vAcq),1,2), {<[chief]={'A'}>} [chief], {<[chief]={'B', 'C'}>} [chief])

but the part <[chief]={'A'}>} [chief] doesn't work.

I tried chief='A' but it displays 0 or -1.

does someone know how can I keep and display chief A for part 1 and chief B and C for part 2 ?

Thank you.