topic Re: Activate two fields in a text box in QlikView

Activate two fields in a text box

danialier — Thu, 23 Jan 2014 10:41:28 GMT

Hello,

I have a text box in Sheet A. By clicking this text box I want to move to Sheet B and by selecting two fields (product Z + product Y) on that Sheet B.

In order to activate Sheet B by clicking the text box in the Sheet A I just added an action -> activate sheet in this text box. That's ok.

In order to activate product Z in Sheet B by clicking the text box in the Sheet A I just added an action -> select in field (search string -> product Z) in this text box. That's ok.

However, the question is: how I can also activate product Y ???

Thanks,

dani

Re: Activate two fields in a text box

Thu, 23 Jan 2014 10:44:26 GMT

in the action for activating the products you have to add the searchstring like this =('product Z'|'product Y')

regards,

Re: Activate two fields in a text box

jonathandienst — Thu, 23 Jan 2014 10:47:26 GMT

I assume you mean two values from one field. In the select in field action use the syntax (A | B) in the search string.

HTH

Jonathan

Re: Activate two fields in a text box

danialier — Thu, 23 Jan 2014 11:08:13 GMT

Hi MT,

I tried and it says “Error in expression” –see below–… Do you know why ?

Thks,dani

Re: Activate two fields in a text box

Thu, 23 Jan 2014 11:46:48 GMT

try it with the = at the beginning!!

Re: Activate two fields in a text box

danialier — Thu, 23 Jan 2014 11:52:01 GMT

Hi Magdalena,

I already tried, see picture attached.

Thks,dani

Re: Activate two fields in a text box

sudeepkm — Thu, 23 Jan 2014 11:53:42 GMT

Please Try like below in Select in field action:

Field

Region (Remove equals sign from here just the field name)

(In my example Field name is Region)

Search String

='("ASIA PACIFIC" | "LATIN AMERICA")'

Re: Activate two fields in a text box

Thu, 23 Jan 2014 11:57:13 GMT

take away the = from the field name then it should work

Re: Activate two fields in a text box

danialier — Thu, 23 Jan 2014 12:01:12 GMT

Excellent !!!!!!!! It works now. many thanks !!!