topic Re: Selecting Multiple Values in field using a variable in QlikView

Selecting Multiple Values in field using a variable

Tue, 06 Jan 2015 07:57:13 GMT

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

Search String:

=ValueList($(vVar))

It is not working as expected.

Please share your experience and knowledge.

Thanks in advance.

Regards,

Sakir

Re: Selecting Multiple Values in field using a variable

jagan — Tue, 06 Jan 2015 08:04:51 GMT

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.

Re: Selecting Multiple Values in field using a variable

Tue, 06 Jan 2015 09:05:57 GMT

It worked. Thanks a lot Jagan.

Re: Selecting Multiple Values in field using a variable

renjithpl — Thu, 08 Sep 2016 10:18:49 GMT

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?

Re: Selecting Multiple Values in field using a variable

renjithpl — Thu, 08 Sep 2016 10:30:01 GMT

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