Finding an Associative Value of a selected item

[#1]

Hi there,

How do i find an associated value of a selection, so if i have value X in a selection box, i want to return y that is associated to it via the model.

anyone?

[MindaugasBacius]

Create new Text object:

=concat(YourField, ';')

[#3]

So thats my selection box, i have a value of 62 (for example) in another field that i want to place into a variable, obviously this then changes every time the user changes their selection, so that the straight table then changes accordingly

[swuehl]

You can use a variable definition with an expression, so the variable value gets updated each time the selection is changed:

The Magic of Variables

It will depend on the relation between your fields and your requirement which aggregation function you should use:

Use Aggregation Functions!

If you expect a single related field value, Only() could do what you want:

=Only(CycleField)

The associative logic is applied by default, it also affects all charts' dimensions and expressions. So maybe you don't even need a variable to apply changes to your chart.