Match selected values in expression

Fri, 16 Oct 2009 04:32:16 GMT

Lets say i load the following inline table


LOAD * INLINE [
 Id, Value
 1, A
 2, B
];

and the following variables


SET A = 1;
SET B = 2;

Then I create a Listbox with field "Value", so the user can select none of them, all of them or just one of them.

Then I create a chart where the expression in the chart will depend on if one of the values is selected. I.e. I would like an expressions like


IF(IsSelected(Id, A), ..., ...)

I have looked at the GetFieldSelections() function but that will not give me the "Id" field when the selectbox displays the "Value" field.

Is this possible? If so what would be the simpliest and most elegant way of doing this? I could always match the "Value" but I don't want to if I don't have to.

br
Per-Anders Söderqvist

topic Match selected values in expression in QlikView

Match selected values in expression