Set Variable on event trigger Field

[kris_vliegen]

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

[#2 · Accepted solution]

instead of =Stationid

try

=GetFieldSelections(Stationid)

or

= only(Stationid)

I assume Stationid is a field in the tables.

[kris_vliegen]

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.

[Clever_Anjos]

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

[kris_vliegen]

Thank you both to help me find the solution.

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

Regards,

Kris

[kris_vliegen]

Hi, A next question.

Why do I get no value in my textfield?

Regards,

Kris

[Clever_Anjos]

Try this

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

[kris_vliegen]

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?

[Clever_Anjos]

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

[kris_vliegen]

Yes, but I have found the solution here

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

Regards,

Kris