Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set trigger to select multiple values in a field from a variable

Hi Guys,

I have created an input box where a user can paste multiple values of a field. So a user will post mutiple values for a field in the input box and I am storing that in a varibale. I am not sure how can I set up a trigger that would take the values from the variable and select a field with those multiple values.

I know how to set up a trigger if there is only one value but for mutiple values its not working.

Can anyone please suggest anything?

Thank you.

1 Solution

Accepted Solutions
MayilVahanan

hi

PFA

Thanks & Regards,
Mayil Vahanan R

View solution in original post

7 Replies
diegofcaivano
Partner
Partner

Hi. You need to use pipes to separate values and double quotes to define each value.

Set an action, and use this as field value:

("VALUE 1"|"VALUE 2")

Regards.

MayilVahanan

Hi

Are you expect like this attached file?

Thanks & Regards,
Mayil Vahanan R
Not applicable
Author

Thanks for your reply everyone.

So the variable that I have set up will contain multiple values for a field seperated by comma. Eg.

ABC, EFF, (123FED), .....

So all these values are stored in one variable. But when I am setting a trigger action, its not working on these multiple values. I am not sure how can I use Pipe in this.

Gysbert - you said seperated by Pipe and enclosed in parenthesis. Can you give an example? Are you trying to say that values seperated by comma is not going to work?

Thanks again. I really appreciate all your inputs.

Not applicable
Author

Hi Mayil, yes I am expecting something like this. But my data in not in num format, its a char data type. Thanks!

MayilVahanan

hi

PFA

Thanks & Regards,
Mayil Vahanan R

View solution in original post

Not applicable
Author

Thanks everyone for replying. It worked.

adriano_fornoni
Contributor III
Contributor III

Grazie, il suggerimento è stato sfruttato con successo.