Link field in data island to expression result in chart

[tracysmart]

Hi All

after a few months away from Qlik I am dusting the cobwebs off my brain and getting a bit stuck with the following...

I have a static data island that contains a list of values and their corresponding scores.

I then have a chart that calculates an expression value alongside dimensions, changeable with user selections.

I want to provide a new expression that takes the result of expression in the second column, and retrieves the corresponding score from the data island.

so the result for XZ6 - 0.944 would return a score of 0.8880

I have tried so many different things that I am just confusing myself now.

What is the best way to do this?

[marcus_sommer · Accepted solution]

You could try something like this:

pick(match(num(round(YourExpression, 0.001), '0.0000'), $(=concat(Value, ','))), $(=concat(Score, ',')))

- Marcus

[tracysmart]

Hi Marcus

thank you for pointing me in the right direction, this works perfectly for my needs.

Tracy