How to do Currency conversion on QlikSense based on selected Currency filter

[#1]

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

[shraddha_g]

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.