topic Re: Select in Field - Multiple strings for single field in QlikView

Select in Field - Multiple strings for single field

Mon, 15 Oct 2012 14:23:33 GMT

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.

Re: Select in Field - Multiple strings for single field

Miguel_Angel_Baeyens — Mon, 15 Oct 2012 14:30:33 GMT

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

Re: Select in Field - Multiple strings for single field

fdelacal — Mon, 15 Oct 2012 14:36:19 GMT

I THINK YOU ARE LOKKINGFOR SOMETHING LIKE THIS.

SEE ATACH.

Re: Select in Field - Multiple strings for single field

Mon, 15 Oct 2012 14:47:47 GMT

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?

Re: Select in Field - Multiple strings for single field

Miguel_Angel_Baeyens — Mon, 15 Oct 2012 14:54:37 GMT

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

Re: Select in Field - Multiple strings for single field

Mon, 15 Oct 2012 15:03:52 GMT

Hi Miguel,

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

Lewis