Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.