topic Select In Field more than one result in QlikView

Select In Field more than one result

Tue, 06 Nov 2012 14:49:58 GMT

I want to create a button that will enable me to select more than one search string. For example, I want to select Both November and December when i click the button. Right now it is either one, it does not choose both for me. Help

Re: Select In Field more than one result

Anonymous — Tue, 06 Nov 2012 14:51:49 GMT

You can use advanced search. Here's an example from the F1 help in QlikView:

=MyField like 'A* or MyField like '*Z'

if e.g. invoked from a list box containing the field MyField, the search would return all field values either starting with the letter A or ending with the letter Z.

Re: Select In Field more than one result

MayilVahanan — Tue, 06 Nov 2012 14:55:44 GMT

Try like this

='(*'&'November'&'*|*'&'December'&'*)'

Hope it helps

Re: Select In Field more than one result

Vegar — Tue, 06 Nov 2012 15:01:26 GMT

Hi,

Try

='(November|December)'

='(November OR December)'

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se