Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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
MVP & Luminary
MVP & Luminary

Re: Selecting Multiple Values in field using a variable

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.

4 Replies
MVP & Luminary
MVP & Luminary

Re: Selecting Multiple Values in field using a variable

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

Re: Selecting Multiple Values in field using a variable

It worked. Thanks a lot Jagan.

renjithpl
Valued Contributor

Re: Selecting Multiple Values in field using a variable

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
Valued Contributor

Re: Selecting Multiple Values in field using a variable

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