Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
kris_vliegen
Partner - Creator III
Partner - Creator III

Set Variable on event trigger Field

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

Variabele.JPG

1 Solution

Accepted Solutions
Not applicable

instead of =Stationid

try

=GetFieldSelections(Stationid)

or

= only(Stationid)

I assume Stationid is a field in the tables.

View solution in original post

9 Replies
Not applicable

instead of =Stationid

try

=GetFieldSelections(Stationid)

or

= only(Stationid)

I assume Stationid is a field in the tables.

kris_vliegen
Partner - Creator III
Partner - Creator III
Author

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.

Variabele.JPG

Clever_Anjos
Employee
Employee

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

kris_vliegen
Partner - Creator III
Partner - Creator III
Author

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
Partner - Creator III
Partner - Creator III
Author

Hi, A next question.

Why do I get no value in my textfield?

Regards,

Kris

Variabele.JPG

Clever_Anjos
Employee
Employee

Try this

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

kris_vliegen
Partner - Creator III
Partner - Creator III
Author

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?

Variabele1.JPG

Clever_Anjos
Employee
Employee

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

kris_vliegen
Partner - Creator III
Partner - Creator III
Author

Yes, but I have found the solution here

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

Regards,

Kris