Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

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

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

1 Reply
shraddha_g
Honored Contributor III

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

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.