Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

value selection with the click of another value in list box

I have 2 list boxes

One button has Region defined

Region

USA

CAD

2nd Button has currency defined.

Currency

USD

CAD

they are not joined.

When I click on USA I want the USD to be selected and when I click on Canada,CAD to be selected.Is this possible with

getfieldselecton or any other function ?

Thank you much.

5 Replies
tresesco
MVP
MVP

Possible. Like in attached sample (using trigger). However, better option is to use the association in data model.

cristinapo
Contributor III
Contributor III

I guess the easiest way would be to use a lync table that can have the two columns mapping each region to its currency like:

Region  Currency

USA        USD

CAD        CAD

How does your table structure look like? Where do these two columns show up, I mean do you need to use them separately?

KR

Cristina

apthansh
Creator
Creator
Author

Thank you.This is how I want but where is the trigger applied ?

tresesco
MVP
MVP

Settings->Document Properties->Field Event Triggers-> Select field 'Currency'->OnSelect->Edit Actions..

apthansh
Creator
Creator
Author

I also have to do this in qliksense,so is there a way to do it in object level instead of in  document properties, ?