Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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, ?