topic Re: Set Variable on event trigger Field in QlikView

Set Variable on event trigger Field

kris_vliegen — Tue, 13 Jan 2015 15:24:12 GMT

Hi All,

I have a listbox. And If I select 1 field in thes listbox I would like to get that value in a variable.

I'm trying wwith Document Properties -> Triggers -> Field EventTriggers -> On select.

What should I write in the value-field?

Regards,

Kris

Re: Set Variable on event trigger Field

Tue, 13 Jan 2015 15:28:44 GMT

instead of =Stationid

try

=GetFieldSelections(Stationid)

= only(Stationid)

I assume Stationid is a field in the tables.

Re: Set Variable on event trigger Field

kris_vliegen — Tue, 13 Jan 2015 15:35:18 GMT

Hi Mario,

StationId is the Id of the Station_Name (Name_eigen)

So If I select 1 station I would like to put the Id in the variable.

But both your solutions doesn't work for me.

Re: Set Variable on event trigger Field

Clever_Anjos — Tue, 13 Jan 2015 15:38:29 GMT

What happens if you put = only(Stationid) in a textbox?

Re: Set Variable on event trigger Field

kris_vliegen — Tue, 13 Jan 2015 15:44:34 GMT

Thank you both to help me find the solution.

The only()-function is working. I was looking to a wrong field.

Regards,

Kris

Re: Set Variable on event trigger Field

kris_vliegen — Tue, 13 Jan 2015 15:54:56 GMT

Hi, A next question.

Why do I get no value in my textfield?

Regards,

Kris

Re: Set Variable on event trigger Field

Clever_Anjos — Tue, 13 Jan 2015 16:07:31 GMT

Try this

=avg({<stationid={"$(=vEigenStation)"}>}DagPrijs)

Re: Set Variable on event trigger Field

kris_vliegen — Wed, 14 Jan 2015 11:09:00 GMT

Thanks! this is working fine.

But now I would like to fil up the whole AVGPrijs-colum with that value

How should I do this?

Re: Set Variable on event trigger Field

Clever_Anjos — Wed, 14 Jan 2015 16:44:36 GMT

I don´t understand, you want fill all values, including values not selected by vEigenStation?

Re: Set Variable on event trigger Field

kris_vliegen — Thu, 15 Jan 2015 07:31:00 GMT

Yes, but I have found the solution here

http://community.qlik.com/message/694824?et=watches.email.thread#694824

Regards,

Kris