topic Re: Select multiple value from a field using trigger in QlikView

Select multiple value from a field using trigger

Mon, 26 May 2014 10:53:37 GMT

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

Mon, 26 May 2014 10:57:41 GMT

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

='(3RDPARTY|ACCREC*)'

Regards,

Prabhu

Mon, 26 May 2014 11:02:12 GMT

Hi Prabhu

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

Thank again brother