Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
nidhibatra10
Contributor II
Contributor II

Selecting Multiple fields in "Select in field" trigger

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

1 Solution

Accepted Solutions
mdmukramali
Specialist III
Specialist III

Hi,

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

281740.PNG

PFA.

View solution in original post

11 Replies
mdmukramali
Specialist III
Specialist III

Hi,

Use

(2016|2017)

jyothish8807
Master II
Master II

Hi Nidhi,

Create a "Select in Field" trigger.

=(2016|2017)

Br,

KC

Best Regards,
KC
nidhibatra10
Contributor II
Contributor II
Author

Hey,

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

mdmukramali
Specialist III
Specialist III

Hi,

Can you share the file.

nidhibatra10
Contributor II
Contributor II
Author

Yes, sure.

sunny_talwar

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'

sunny_talwar

Both these seems to be working

Capture.PNG

mdmukramali
Specialist III
Specialist III

Hi,

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

281740.PNG

PFA.

neha_shirsath
Specialist
Specialist

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


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