topic Passing a field value to another field in QlikView

Passing a field value to another field

Thu, 28 Oct 2010 06:10:23 GMT

Hi,

I want to pass the values selected in 'Field 1' as a filter for 'Field 2'. I tried using a variable to get the selected values of 'Field 1' and pass the variable value to 'Field 2' using set analysis. But, the variable value is always null. The variable definition I used is given below:


getFieldSelections([Field 1])

I am not sure why the variable is not getting the selected 'Field 1' values. Is there any other way to resolve this?

Thanks in advance.

-Haneesh

Passing a field value to another field

Thu, 28 Oct 2010 06:33:36 GMT

hi,

If there is a single value selection then you can do this by using trigger.

You have to go in the document properties trigger-->field event trigger---->select the field on that selection is going on ----> add action on select ----->choose external----->set variable---->Give the name of variable you have defined to store the vale ----->in the value just put the name of the field in which selection will be done.

You can able to find the value of selection in your defined variable.which can be used for the other purpose.

regards,

Ravi

Passing a field value to another field

Thu, 28 Oct 2010 06:54:10 GMT

Thanks Ravi. Unfortunately this is not a single value selection. Will this work for multi select also?

Thanks,

Haneesh

Passing a field value to another field

Thu, 28 Oct 2010 07:50:20 GMT

Check whether you are using the same field name([Field 1]) for any variables. If so, change the variable name.

Passing a field value to another field

Thu, 28 Oct 2010 08:05:59 GMT

I am not using the same name for the variable, but still the selected values are not assigned to the variables.

Can someone throw some lights on this?

-Haneesh

Passing a field value to another field

Thu, 28 Oct 2010 08:15:31 GMT

Hi Haneesh,

I used trigger to save selected values to a variable. You will see in a text box the value passed to a variable. Also in 2nd list box I used the variable in filtering. Hope this one helps

Please see attached file

regards,

Passing a field value to another field

Thu, 28 Oct 2010 09:02:47 GMT

Thanks Ronald.

The attached document does not have any text box and list box. Can you upload the correct file again.

-Haneesh

Passing a field value to another field

sparur — Thu, 28 Oct 2010 09:14:28 GMT

Hello, Haneesh

Please, see in my example.

I created a Result table where I use set analysis for restricting values of field2 by selections on Field1

Passing a field value to another field

Thu, 28 Oct 2010 09:51:25 GMT

Thanks Anatoly.

I have previously done the same. But, the variable value is always null 😞

I am using QV 9 SR3 and have checked this on SR4 also. Could this be due to the version? any ideas?

Regards,

Haneesh

Passing a field value to another field

Thu, 28 Oct 2010 10:02:04 GMT

Hi Haneesh,

Sorry for that.

I re upload my sample file

Passing a field value to another field

sparur — Thu, 28 Oct 2010 10:04:27 GMT

in your variable you should use this value:

=getselectedvalue(Field1)

I think earlier you used value without equal sign.

Passing a field value to another field

Thu, 28 Oct 2010 10:13:51 GMT

agree with Anatoly. 😄

You can achieve this even without trigger. Also if your field has more than one word enclose them with brackets ex:


=GetFieldSelections( [Field Name Here])

Passing a field value to another field

Thu, 28 Oct 2010 10:54:59 GMT

Got it.

The reason was that my variable name has a space in between (v_Product Name) and so, the selected values were not displayed. Now changed the variable name and it is working.

Thanks a lot for all your help.

Cheers,

Haneesh

Passing a field value to another field

Wed, 15 Dec 2010 18:48:03 GMT

HI sparur,

May I ask - in your test.qvw, when you are changing selections in Field1, how are you getting that to change the Variable1 value please ? I just cannot see it ...

Thanks

Bpb

Passing a field value to another field

Thu, 16 Dec 2010 09:48:24 GMT

HI, don't worry - worked it out thanks !!