How to do Currency conversion on QlikSense based on selected Currency filter
How to do Currency conversion on QlikSense based on selected Currency in Filter area
I have a Examples like below
Date, Item, Currency, Amount
2016-09-09, A, RUPIAH, 3000
2016-09-09, A, USD, 120
2016-09-09, A, INR, 2000
2016-08-14, B, EUR, 100
2016-08-14, B, INR, 2100
2016-08-14, B, USD, 50
My currency conversion information is extracting from Excel file.
Based on the above data, If i select USD it has to convert all data into USD dolllars, and if i select EUR it has to appear in EUR's and If i Select INR all values should be shown in INR. This Currency filter i am going to provide in filter area.
If anyone has done this scenario already in QlikSense kindly please help me.