Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selecting Multiple Values in field using a variable

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

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

4 Replies
jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

It worked. Thanks a lot Jagan.

renjithpl
Specialist
Specialist

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
Specialist
Specialist

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