Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
It worked. Thanks a lot Jagan.
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?
Sorry Jagan, my bad, i missed the brackets ( ). , it works fine.