topic Re: currency conversion in QlikView

currency conversion

Tue, 08 Jul 2014 10:56:44 GMT

hi,

how can i convert or toggle betwwen any currency to USD and AED.for eg i have 10rs so i want a list box having USD and AED and when i click to USD this 10rs should convert into USD and when i click AED this 10rs should convert into AED.

Re: currency conversion

Tue, 08 Jul 2014 11:01:16 GMT

Hi Darshika,

My suggestion is to import a table with the currency.

For example:

CURRENCY:

LOAD

Currency, Exchange

FROM xxx.xls.

Then you add this as a selection box but with one figure always selected. And based on this you multiply your figure by the exchange, like so. Sales * Exchange.

Regards,
Marius

Re: currency conversion

Wed, 09 Jul 2014 03:35:35 GMT

Hi marius,

thanks but i already have those column having the values(in USD and AED)now i want two buttons one say USD and another one as AED and now if i click to USD the other graphs on my sheet should change accordingly as i toggle

Re: currency conversion

Wed, 09 Jul 2014 04:53:35 GMT

Hi,

Can you share the sample file.

Re: currency conversion

PradeepReddy — Wed, 09 Jul 2014 05:11:53 GMT

Try some thing like this.

Create a variable 'vCurrency' and assign the currently selected value(Currency Value) to it.

In all expressions use the variable 'vCurrency'

Ex: Sum(Sales)/vCurrency

If you want to use the buttons instead of List box,

Create 2 buttons(USD, ADE) and assign the currency values to the variables from Properties--> Action.

In all expressions use the variable 'vCurrency'.

Regards,

Pradeep

Re: currency conversion

Wed, 09 Jul 2014 05:14:03 GMT

thanks pradeep taniparthy,i tried its working perfectly

Re: currency conversion

Wed, 09 Jul 2014 05:21:09 GMT

Hi,

Please find the attachement. Hope this will be helpfull

Re: currency conversion

PradeepReddy — Wed, 09 Jul 2014 05:30:36 GMT

Close the thread by marking Correct answer, so that it will be helpful for others.