How to use FieldSelections to pull value from seperate table
I am trying to build a visualisation in one of my Qlik Apps which essentially does the following, I will have a drop down list of advisers, for example:
I will then have a seperate table with targets, but this can also include combined targets for 2 advisors, or more. Example being:
now it would be good noting there is no formula relating to AA's target and BB's - or they are not a calculated version but essentially depending on the selection on the app you use - it would bring up the selection for this target.
At the moment i can use GetFieldSelections(Advisor) so if i click AA & BB on the dropdown i get "AA, BB"
I would then like to look up this seperate table which is not joined to other data tables and bring through the target value. I have tried using FieldValue and FieldIndex but am not getting it to work, and Peek/ match functions are script only. This is for the chart side so any ideas would be greatly appreciated. It would also be good noting i'm only interested in if the values match something in the table so if i select something not in AdvisorSelection im happy for it to show blank aswell. Hopefully this makes sense?
Re: How to use FieldSelections to pull value from seperate table
Hi, this didnt work on my version of qliksense but the comment i put above does - odd! it looks like it would be right, but the extra dollar sign seemed to have fixed it.
As for the ordering, it will do the selections alphabetically as I have tested doing this backwards so this seems to work. Its not a great solution to a weird question as I ideally would like all the targets to add up or have some sort of logic behind, but it works for what I need!