topic Currency Conversions using variables in QlikView

Currency Conversions using variables

Thu, 11 Jun 2015 15:36:37 GMT

Hello,

I was wondering if anyone could help me create a variable which would allow me to switch between currencies on graphs? I have created a new column in my data source with the normal GBP amount as 1 and my USD convertor column as 1.55. I want to be able to create a variable so that I can click on a button and it will switch my close price of my graphs between USD and GBP?

Any help would be much appreciated.

Thanks

Re: Currencty Conversions using variables

petter — Thu, 11 Jun 2015 17:44:07 GMT

It is quite easy. You could create an INPUT BOX and when making it you create a variable that will be displayed in the INPUT BOX. Call the variable for instance vCurrRate.

Then you can input the currency conversion rate in that variable directly in the INPUT BOX.

Multiply the expressions in your charts where you want to be able to switch currencies by vCurrRate.

Sum( Sales ) * vCurrRate

This could be made more sophisticated by having a currency conversion rate table instead where you just select the currency in a LIST BOX and you have a predefined table of Currency, CurrRate and multiply by CurrRate just like the variable.

Re: Currencty Conversions using variables

Thu, 11 Jun 2015 17:56:32 GMT

Thank you so much Petter, that makes it very easy for me

Re: Currencty Conversions using variables

petter — Thu, 11 Jun 2015 18:52:51 GMT

If my suggestion was the answer to your question could you please mark this question as answered?

Re: Currencty Conversions using variables

pratap6699 — Thu, 11 Jun 2015 19:46:52 GMT

let vrate=50(exchange rate); then as usual we load data then…main--newsheet obj--chart straight-- dimension(year)--- expresion(sales)---finish..then; SETTINGS--VARIABLE OVERVIEW-- VARIABLE OVERVIEW WINDOW DISPLAYED--ADD--vcuràinr--OK.,,,need 2 extra buttons so…(1)mainànew sheet obj--button--text(inr)àaction tab---add--external--set variable --OK. action tab--variable(vcur)-value(inr)--OK.(2) mainànew sheet objàbutton--text(GBR) ---action tab--add---external---set variable---OK.action tab --- variable(vcur)-value(GBR)--OK…right click on tablechart-- properties--- expressions --- defination--- if(vcur=’inr’,sum(sales),sum(sales)*vrate)---OK---OK