topic Re: Set trigger to select multiple values in a field from a variable in QlikView https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385689#M144035 <HTML><HEAD></HEAD><BODY><P>Thanks everyone for replying. It worked.</P></BODY></HTML> Tue, 30 Oct 2012 20:28:39 GMT 2012-10-30T20:28:39Z Set trigger to select multiple values in a field from a variable https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385683#M144029 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>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. </P><P>I know how to set up a trigger if there is only one value but for mutiple values its not working.</P><P> Can anyone please suggest anything?</P><P></P><P>Thank you.</P></BODY></HTML> Tue, 30 Oct 2012 17:56:32 GMT https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385683#M144029 2012-10-30T17:56:32Z Re: Set trigger to select multiple values in a field from a variable https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385684#M144030 <HTML><HEAD></HEAD><BODY><P>Hi. You need to use pipes to separate values and double quotes to define each value.</P><P></P><P>Set an action, and use this as field value:</P><P>("VALUE 1"|"VALUE 2")</P><P></P><P>Regards.</P></BODY></HTML> Tue, 30 Oct 2012 18:06:02 GMT https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385684#M144030 diegofcaivano 2012-10-30T18:06:02Z Re: Set trigger to select multiple values in a field from a variable https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385685#M144031 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> Are you expect like this attached file?</P></BODY></HTML> Tue, 30 Oct 2012 18:06:08 GMT https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385685#M144031 MayilVahanan 2012-10-30T18:06:08Z Re: Set trigger to select multiple values in a field from a variable https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385686#M144032 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply everyone. </P><P></P><P>So the variable that I have set up will contain multiple values for a field seperated by comma. Eg. </P><P></P><P>ABC, EFF, (123FED), .....</P><P></P><P>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.</P><P></P><P>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?</P><P></P><P></P><P>Thanks again. I really appreciate all your inputs. </P></BODY></HTML> Tue, 30 Oct 2012 18:18:20 GMT https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385686#M144032 2012-10-30T18:18:20Z Re: Set trigger to select multiple values in a field from a variable https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385687#M144033 <HTML><HEAD></HEAD><BODY><P>Hi Mayil, yes I am expecting something like this. But my data in not in num format, its a char data type. Thanks!</P></BODY></HTML> Tue, 30 Oct 2012 18:19:29 GMT https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385687#M144033 2012-10-30T18:19:29Z Re: Set trigger to select multiple values in a field from a variable https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385688#M144034 <HTML><HEAD></HEAD><BODY><P> hi</P><P></P><P>PFA</P></BODY></HTML> Tue, 30 Oct 2012 18:26:41 GMT https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385688#M144034 MayilVahanan 2012-10-30T18:26:41Z Re: Set trigger to select multiple values in a field from a variable https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385689#M144035 <HTML><HEAD></HEAD><BODY><P>Thanks everyone for replying. It worked.</P></BODY></HTML> Tue, 30 Oct 2012 20:28:39 GMT https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385689#M144035 2012-10-30T20:28:39Z Re: Set trigger to select multiple values in a field from a variable https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385690#M144036 <HTML><HEAD></HEAD><BODY><P>Grazie, il suggerimento รจ stato sfruttato con successo.</P></BODY></HTML> Mon, 01 Jun 2015 15:25:01 GMT https://community.qlik.com/t5/QlikView/Set-trigger-to-select-multiple-values-in-a-field-from-a-variable/m-p/385690#M144036 adriano_fornoni 2015-06-01T15:25:01Z