topic Re: Selecting Multiple fields in "Select in field" trigger in QlikView

Selecting Multiple fields in "Select in field" trigger

nidhibatra10 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In the "Select in Field" action, how do you assign multiple values to a field? I want that when I open the document, two values should be selected by default. I tried ("2016" | "2017") for the field "Year".But it's not working

Re: Selecting Multiple fields in "Select in field" trigger

mdmukramali — Wed, 15 Nov 2017 08:35:12 GMT

Hi,

Use

(2016|2017)

Re: Selecting Multiple fields in "Select in field" trigger

jyothish8807 — Wed, 15 Nov 2017 09:02:56 GMT

Hi Nidhi,

Create a "Select in Field" trigger.

=(2016|2017)

Br,

Re: Selecting Multiple fields in "Select in field" trigger

nidhibatra10 — Wed, 15 Nov 2017 09:09:34 GMT

Hey,

I tried it, but it's still not working.

Re: Selecting Multiple fields in "Select in field" trigger

mdmukramali — Wed, 15 Nov 2017 09:12:24 GMT

Hi,

Can you share the file.

Re: Selecting Multiple fields in "Select in field" trigger

nidhibatra10 — Wed, 15 Nov 2017 09:19:22 GMT

Yes, sure.

Re: Selecting Multiple fields in "Select in field" trigger

sunny_talwar — Wed, 15 Nov 2017 09:20:10 GMT

Would you be able to share a screenshot (if not a sample) to show how does Year field look in a list box. Alternatively, would you be able to share script you use to create year field?

Also, give this a shot also

='>=2016<=2017'

Re: Selecting Multiple fields in "Select in field" trigger

sunny_talwar — Wed, 15 Nov 2017 09:21:50 GMT

Both these seems to be working

Re: Selecting Multiple fields in "Select in field" trigger

mdmukramali — Wed, 15 Nov 2017 09:23:51 GMT

Hi,

OnOpen Application if you want to apply trigger condition then goto Document properties-->Tirgger

PFA.

Re: Selecting Multiple fields in "Select in field" trigger

neha_shirsath — Wed, 15 Nov 2017 09:27:02 GMT

Action > Select in fields> Field=Year & Search string= (2016|2017)

This should work, no equals sign, no quotes, but include the brackets.

Re: Selecting Multiple fields in "Select in field" trigger

neha_shirsath — Wed, 15 Nov 2017 09:30:17 GMT

Your Application is working correctly.

Just add new sheet and go back to 1st sheet, as you have given trigger on Activate sheet.

This will select 2016 & 2017 when you go to respective sheet.

Re: Selecting Multiple fields in "Select in field" trigger

nidhibatra10 — Wed, 15 Nov 2017 09:33:04 GMT

Thank you. It worked