Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Like this?
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
You only click on Sweden.
See the attached app: (first sheet)
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.
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.