populate values on field selection from filter pane

[Aspiring_Developer]

Hello Everyone,

I searched a lot and found nothing much as of and i am struggling on how to achieve below in qliksense:-

Data_Table:

Scenario	Year	Entity Code	Entity name	Country	Entity Reporting Currency	Amount	New_Amount(calculated using apply map currency table)
Budget Rate N	2021	ARS	201	USA	USA	480	50
Budhet N-1	2020	USD	226	Europe	EUR	490	10
Budget Rate N	2021	EUR	501	Argentina	ARS	500	40

Exchange_Rate: (mapping table)

Scenario	Year	Entity Reporting Currency	Exchange Rate
ActualN-1	2019	ARS	10
Budhet N-1	2020	USD	50
Budget Rate N	2021	ARS	70

My requirement is to create a filter /dropdown at front end in qliksesne like and let user select the scenario to see the data. So create an inline table:-

Temp:
Load * inline [

Dimension
ActualN-1      //2019
BudgetN-1    //2020
BudgetRateN   //2021

];

When user select "BudgetRate N" for currency ARS, it should populate the value with respect to below:- 

Data table

Budget Rate N

2021

ARS

201

USA

USA

480

Mapping table

Budget Rate N

2021

ARS

70

  New amount= 480/70

===========================================================================

Now we do not have any data for Actuals N-1 in our raw data, so the client wants , if user select "ActualN-1" from filter pane dropdown, then 

-it should pick the corresponding exchange rate  i..e 10:

ActualN-1

2019

ARS

10

-And calculate all the values (Budget RateN & Budget Rate N-1) using this exchange rate .

So all the table data should show the values using this exchange rate.

Can anyone please help me on this?

@sunny_talwar  @Kushal_Chawda