Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Highlighted
MVP
MVP

Re: Select in Field - Multiple strings for single field

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

5 Replies
Highlighted
MVP
MVP

Re: Select in Field - Multiple strings for single field

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
Valued Contributor

Re: Select in Field - Multiple strings for single field

I THINK YOU ARE LOKKINGFOR SOMETHING LIKE THIS.

SEE ATACH.

Not applicable

Re: Select in Field - Multiple strings for single field

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?

MVP
MVP

Re: Select in Field - Multiple strings for single field

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

Re: Select in Field - Multiple strings for single field

Hi Miguel,

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

Lewis

Community Browser