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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select multiple value from a field using trigger

Hello guys.

I need to create a trigger in a sheet to select multiple values from a field.

Say the field is CustomerPostingGroup and the value that I need to select in the trigger is strings 3RDPARTY and ACCREC'BLE.

And please take not that there is an apostrophe (') in the ACCREC'BLE string.

How do I do this? I know we can add Triggers in the OnActivateSheet and add a Select in Field action. I input the CustomerPostingGroup as the Field.

But how do I enter in the Search String if I wanted to trigger selection of two values?

Thank you very much for your kind attention guys

1 Solution

Accepted Solutions
Not applicable
Author

Apply select in field trigger and add this is in search string

='(3RDPARTY|ACCREC*)'

Regards,

Prabhu

View solution in original post

2 Replies
Not applicable
Author

Apply select in field trigger and add this is in search string

='(3RDPARTY|ACCREC*)'

Regards,

Prabhu

Not applicable
Author

Hi Prabhu

Thank you for your answer! the ' ' should be outside of ( ).. now I know why mine didn't work

Thank again brother