topic Re: Re: Help with Select In Field in QlikView

Help with Select In Field

Tue, 05 Nov 2013 17:38:47 GMT

Hi Guys

I have a problem here

I have set the button from my landing page to move to another tab, clear all, and select the object. I can also get it to choose a single entry using the 'Select In Field' functionality.

But I cannot get it to select more than one item in the field

my field called PLE has values ..

B718P

B719P

B720P

B111P

B99P

and from the landing page, I want to select 3 of the values.

I have tried

(B719P|B111P|B99P)

=('*B719P*' or '*B111P*' or '*B99P*')

and many other conbinations

Can anyone advise please?

Thanks

John

Re: Help with Select In Field

tresB — Tue, 05 Nov 2013 17:45:15 GMT

Check if 'Always One Selected Value' is enabled. Or, could you post a sample?

Re: Help with Select In Field

Tue, 05 Nov 2013 17:51:24 GMT

The field it is trying to filter is just a Straight Table, with one dimension and one value field which is an aggregated field, and I would like to auto select from another tab multiple values in the dimension field.

Manually, holding down the CTRL key, you can select multple values, but using the 'Select in field' action on a button from another sheetdoes not select more than one.

Re: Help with Select In Field

tresB — Tue, 05 Nov 2013 17:56:19 GMT

Selecting multiple values should not be an issue. Please share your sample app to find the actual issue.

Re: Re: Help with Select In Field

Tue, 05 Nov 2013 18:07:53 GMT

Here is the example, I hoope this is something obvious

thanks

Re: Re: Re: Help with Select In Field

tresB — Tue, 05 Nov 2013 18:18:28 GMT

PFA.

Used search string: (B719P|B111P|B99P)

Re: Help with Select In Field

Gysbert_Wassenaar — Tue, 05 Nov 2013 18:29:18 GMT

These two work:

(B719P|B111P|B99P)
= '(B719P or B111P or B99P)'

Re: Re: Help with Select In Field

Tue, 05 Nov 2013 18:34:48 GMT

I dont know why, but in my 'real' dashboard, only the second one works!

Thank you both VERY much for your help

John