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.
kolakiran
New Contributor II

Currency conversion in Qliksense

Hello experts,

I have a scenario in Qliksense if i select the USD the data is converted and show in USD,... in the same way if i select the INR the data is converted and show in INR, let us say base currency Indonesian Rupiah  ...like that for other currencies in the world. i need to put one filter for Currencies.

How can i achieve this scenario.

Thanks in Advance.

Regards

Kiran

6 Replies
shraddha_g
Honored Contributor III

Re: Currency conversion in Qliksense

Hi,

You can create a variable with currency rate or currency

And then use that variable in extension.

For this purpose you can useQlik Branch extension.

User can select currency from available buttons and according to selection value will change..

I hope this is helpful.

lakshmikandh
Valued Contributor II

Re: Currency conversion in Qliksense

Have a currency master table with your base currency to other currency conversion rates,

Like this

Effective From | Effective To | AUD | USD | GBP | SGD | INR | etc

as mentioned by shraddha.g‌ use the qsVariable extension and create a Variable "vCurrency" and select the option of combo and add all the currencies with value & label (like 1: USD, 2:AUD,etc ) into the extension.

When user selects currency in combo the variable will get values assigned like 1,2,3,4,etc based on currency,

In your chart expression use like Base_Currency_Value * pick(match($(vCurrency),'1','2','3'... etc),USD,AUD,...etc)

In case if you want to include the effective date also in the calculation use if statements and compare with tran_date

Or join this currency master table to transaction table in the load script itself ( tran_date between eff_from and eff_to )

Hope this helps,

Thanks,

Lakshmikandh

rohitk1609
Valued Contributor II

Re: Currency conversion in Qliksense

Hi kiran,

Why do you try Qlik data market once . The Qlik data market exist exactly for your use case .

lakshmikandh
Valued Contributor II

Re: Currency conversion in Qliksense

Yes data market you can purchase license and include that in your app, data market free version has only 3 currencies.

Also those are generic rates, if your transaction system maintains some cut off rates for forex, like its a fixed rate per currency for month or quarter so, you have to go in this fixed table approach.

kolakiran
New Contributor II

Re: Currency conversion in Qliksense

Hi Rohit,

data market is having 3 currencies for  free. i need more than that specified currincies

Regards

Kiran

rohitk1609
Valued Contributor II

Re: Currency conversion in Qliksense

Hi kiran,

If you need full version of data market, ask your Qlik partner for buy a licence for you . secondly if you are not ready to pay for licence , find a source where latest conversion rates are available and match's your use caselike any web file has it and you can access it by web file mode and use it . Try it once please