Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

7 Replies
Highlighted
Partner
Partner

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

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.

Highlighted

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

Hi

Are you expect like this attached file?

Highlighted
Not applicable

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

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.

Highlighted
Not applicable

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

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

Highlighted

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

Highlighted
Not applicable

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

Thanks everyone for replying. It worked.

Highlighted
Contributor III
Contributor III

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

Grazie, il suggerimento è stato sfruttato con successo.