Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Partner - Master III
Partner - Master III

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

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
Master
Master

Hi kiran,

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

lakshmikandh
Specialist II
Specialist II

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.

Anonymous
Not applicable
Author

Hi Rohit,

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

Regards

Kiran

rohitk1609
Master
Master

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