Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select in Field - Multiple strings for single field

Hi all,

Firstly is this possible?

Id like to create a button that selects in field but id like it to select a number of statuses rather than just a single status

for example

Field = [Quote Status]

Search String <> 'Won' OR 'Lost'

Any ideas?

Thanks for all you advice in advance.

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi,

Set it to search

(Win|Lost)

All values without quotes, separated by the "|" symbol, and warped by parentheses., then a new action to select excluded.

Hope that helps.

Miguel

View solution in original post

5 Replies
Miguel_Angel_Baeyens

Hi,

Set it to search

(Win|Lost)

All values without quotes, separated by the "|" symbol, and warped by parentheses., then a new action to select excluded.

Hope that helps.

Miguel

fdelacal
Specialist
Specialist

I THINK YOU ARE LOKKINGFOR SOMETHING LIKE THIS.

SEE ATACH.

Not applicable
Author

Hi Miguel,

This works if I use the

='(Won|Lost)'

but i require the reverse

<>'(Won|Lost)'

which fails to work.  If this it is not possible to <> is something along the lines of ='(Internal Estimate|Order Request|Pending)'  this doesnt seem to work and im guessing its because of the whitespace?

Miguel_Angel_Baeyens

Hi,

Yes, blanks are not welcome in these expressions. Wherever you have a blank, fill it with an "*" instead. Note that I added a new action to select excluded in the same field.

Hope that helps.

Miguel

Not applicable
Author

Hi Miguel,

Sorry missed that attachment, thats exactly what im after, thank you again for your excellent help.

Lewis