Selecting Multiple Values in field using a variable

[#1]

Hi,

I have a problem where I need to select Field on the basis of some calculation. After calculation value is stored in a variable as comma separated values. I need to create a button that will select only those values that are present in that variable.

For Example:

t1:

LOAD * INLINE [

    F1, F2

    a1, a

    b2, c

    c3, v

    e1,d

    f1,g

];

After Calculation

vVar contains a1,c3,f1

Button:

Select in Field:

Field

F1

Search String:

=ValueList($(vVar))

It is not working as expected.

Please share your experience and knowledge.

Thanks in advance.

Regards,

Sakir

[jagan · Accepted solution]

Hi Sakir,

You need to store the values of variable in this format (a1|c3|f1), for button

Properties -> Actions-> Add-> Selections -> Add In Field-> Give Field name in Field

and give your variable in Search String.

Hope this helps you.

Regards,

Jagan.

[#3]

It worked. Thanks a lot Jagan.

[renjithpl]

Hi Jagan,

I have a same scenario, i did the same format, but somehow its not working,

Do you thing, i need to assign the seperator "|" somewhere?

[renjithpl]

Sorry Jagan, my bad, i missed the brackets ( ). , it works fine.