Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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
Highlighted
Partner
Partner

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.

Highlighted
Specialist II
Specialist 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

Highlighted
Specialist III
Specialist III

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 .

Highlighted
Specialist II
Specialist 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.

Highlighted
Contributor II
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

Highlighted
Specialist III
Specialist III

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