topic Re: Multiple values in Select Field in QlikView

Multiple values in Select Field

Wed, 05 Sep 2012 13:17:23 GMT

Hi All

I was looking at various posts within the community to see if anyone has come across a problem of selecting multiple values in "Select in Field" option within actions but haven't come across a solution yet.

I'd like to select multiple fields and their values when clicked on a text object. Something like

Field: Region | City | Town

Search String: UK | London | Mayfair

Thanks for your help.

Kash

Re: Multiple values in Select Field

Wed, 05 Sep 2012 13:20:14 GMT

Why don't you just add three select in field actions to the object with 1 string in each?

Re: Multiple values in Select Field

Wed, 05 Sep 2012 13:29:51 GMT

I have a requirement where in I have to pass in 5 values (use 5 different select fields) across various places within the Qlikview document.

Instead of adding 5 select fields on each of the text object, I was wondering if there is an easy way to pass in multiple values

Re: Multiple values in Select Field

kouroshkarimi — Wed, 05 Sep 2012 13:30:47 GMT

would a macro do the job? you can use activedocument.fields("FieldName").select "Value" and use toggleselect for each other value.

Re: Multiple values in Select Field

Wed, 05 Sep 2012 13:37:37 GMT

Select In Field of just 'Mayfair' will automatically select single member parents in your hierarchy.

Re: Multiple values in Select Field

Wed, 05 Sep 2012 14:02:43 GMT

Hi Klangley

I'd like to pass in the some values from one tab to another hence can't really select the child values.

Thanks for your help anyway.

Re: Multiple values in Select Field

Wed, 05 Sep 2012 14:02:55 GMT

Hi Klangley

I'd like to pass in the some values from one tab to another hence can't really select the child values.

Thanks for your help anyway.

Re: Multiple values in Select Field

Wed, 05 Sep 2012 14:14:01 GMT

Did you try by creating a combined field of Region+City+Town and passing the search string?

Re: Multiple values in Select Field

tanelry — Thu, 06 Sep 2012 09:01:27 GMT

I think the simpliest way is to use bookmark.

Make those selections first, add bookmark (with option to apply "on top of current selections"), and assign action to your button / text object to call the bookmark.