topic Re: Currency Calculation in QlikView

Currency Calculation

rathnam_qv — Tue, 08 Apr 2014 09:35:47 GMT

Hi All,

i have straight table in that i have 4 fields Sales Amount,Discount Amt,Quantity Billed,Ontime Deliverd Revenue...which are having $ values.my requirement is to create two buttons as USD and INR in the sheet.when i click on INR it should display INR value in the above mentioned fields.

can any one help me.

Regards,

Rathnam.

Re: Currency Calculation

MK_QSL — Tue, 08 Apr 2014 09:41:29 GMT

Create a Variable vCUR and set value as 1

Now Create two buttons

one for USD

Set Action as
External >> Set Variable

Variable vCUR

Value 1

Same way make another button for INR and use value as 2

Now in your expression... use vCUR as below

Example

SUM(Quantity * Price * if(vCUR = 1, USDRate,INRRate))

Re: Currency Calculation

its_anandrjs — Tue, 08 Apr 2014 09:53:58 GMT

Update :- Please check now a new update

Create a inline table like

Eg:-

Load * inline

[

CurrencyName, CurrencyRate

USD,1

INR,2

];

Then in the dashboard plot a list box with field CurrencyName and remove its caption from properties

SUM(Quantity * Price * Getfieldselections(CurrencyRate))

then according to your selection in the currency your sum value change.

Re: Currency Calculation

rathnam_qv — Tue, 08 Apr 2014 09:57:52 GMT

Hi Manish,

Thanks for your replay,

now i created one list box with USD,INR and i made them as Radio buttons.now, if i select USD radio button the USD value should change to INR and vice versa in the Straight table.

help me out.

Regards,

RAthnam.

Re: Currency Calculation

rathnam_qv — Tue, 08 Apr 2014 10:02:37 GMT

Hi Anand Chauhan,

Thanks for ur reply..

Ya i already created List box as u suggested.Now if i select INR from the listbox The USD values in the Straight table should display the INR values ad vice Versa (in my straight table 4 fields are there with USD values)

help me out.

Regards,

Rathnam.

Re: Currency Calculation

MK_QSL — Tue, 08 Apr 2014 10:05:56 GMT

Can you post your sample data file or sample apps?

Re: Currency Calculation

its_anandrjs — Tue, 08 Apr 2014 10:14:23 GMT

After adding list box in the application named CurrencyName which contains INR and USD then

in expression write

=if(GetSelectedCount(CurrencyName)=0,Sum(Sales), if(GetSelectedCount(CurrencyName)='INR',sum(Sales) * 1 , Sum(Sales) * 2))

In place of 1 and 2 put currency rates

Re: Currency Calculation

nizamsha — Tue, 08 Apr 2014 10:40:36 GMT

look at The Attachment

Re: Currency Calculation

rathnam_qv — Tue, 08 Apr 2014 11:03:18 GMT

hi Nizam,

i didn't get any attachment

Re: Currency Calculation

nizamsha — Tue, 08 Apr 2014 11:43:56 GMT

I already attached sme changes is made and updated

Re: Currency Calculation

rathnam_qv — Tue, 08 Apr 2014 12:00:34 GMT

Thank you very much Manish

Regards,

Rathnam.