Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:-
Budget Rate N | 2021 | ARS | 201 | USA | USA | 480 |
Budget Rate N | 2021 | ARS | 70 |
ActualN-1 | 2019 | ARS | 10 |