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
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:
-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?