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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

select multiple values

Hello

I got a trigger on one of the sheet and added an action to select multiple values of a field

the field is Business Type

the values are OFFICE and REGIONAL OFFICE

I put in the action the field [Business Type] and in the value I put (REGIONAL OFFICE|OFFICE)

Only OFFICE is selected

values that contain spaces are not being selected

Please advise

I can walk on water when it freezes
1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Try replacing the spaces with *

(REGIONAL*OFFICE|OFFICE)

That appears to work.You can use Replace() to swap the  space for a *

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

1 Reply
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Try replacing the spaces with *

(REGIONAL*OFFICE|OFFICE)

That appears to work.You can use Replace() to swap the  space for a *

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein