Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Hi kiran,
Why do you try Qlik data market once . The Qlik data market exist exactly for your use case .
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.
Hi Rohit,
data market is having 3 currencies for free. i need more than that specified currincies
Regards
Kiran
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