Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi EveryOne,
How to do Currency conversion on QlikSense based on selected Currency in Filter area
I have a Examples like below
Sales;
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
And
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.
Thanks and regards,
Naresh.M
Hi,
You can link excel file with currency field and use currency rate field in expression.. It work on currency selection.
I hope it is helpful.