Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

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

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Set Variable on event trigger Field

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
Highlighted
Not applicable

Re: Set Variable on event trigger Field

instead of =Stationid

try

=GetFieldSelections(Stationid)

or

= only(Stationid)

I assume Stationid is a field in the tables.

View solution in original post

Highlighted
Partner
Partner

Re: Set Variable on event trigger Field

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

Highlighted
Employee
Employee

Re: Set Variable on event trigger Field

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

Highlighted
Partner
Partner

Re: Set Variable on event trigger Field

Thank you both to help me find the solution.

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

Regards,

Kris

Highlighted
Partner
Partner

Re: Set Variable on event trigger Field

Hi, A next question.

Why do I get no value in my textfield?

Regards,

Kris

Variabele.JPG

Highlighted
Employee
Employee

Re: Set Variable on event trigger Field

Try this

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

Highlighted
Partner
Partner

Re: Set Variable on event trigger Field

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

Highlighted
Employee
Employee

Re: Set Variable on event trigger Field

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

Highlighted
Partner
Partner

Re: Set Variable on event trigger Field

Yes, but I have found the solution here

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

Regards,

Kris