topic Re: Auto Currency convert in QlikView

Auto Currency convert

Mahamed_Qlik — Thu, 10 Mar 2016 13:03:13 GMT

Hi,

I have below scenario

Suppose I have below table:Date

ID	Amount	Currency	Date
1	60	USD	01-02-2016
2	300	IND	02-02-2016
3	100	GBP	03-02-2016
4	200	USD	04-02-2016

Now I want to show the Amount with respective to the ID in chart.

But, i need all the Amount should be in USD only.

If i select ID 2 then it should not show the amount as 250 as this is in IND currency rather is should show

in USD (suppose 1 USD =60 IND) then if I select ID 2 then it should show amount as 5 USD.

same for the others.

So assume,

1 USD =60 IND

1 USD = 100 GBP

Kindly help.

Regards,

Mahamed

Re: Auto Currency convert

sunny_talwar — Thu, 10 Mar 2016 13:06:12 GMT

Do you have one static rate you want to convert the rate based on or do you have different rates for different periods? For example do you have this?

XR DATE CURRENCY

60 01/01/2015 IND

61 01/02/2015 IND

65 01/15/2015 IND

Re: Auto Currency convert

Gysbert_Wassenaar — Thu, 10 Mar 2016 13:08:16 GMT

Create a currencies table in the script:

Currencies:

LOAD * INLINE [

Currency, Factor

USD, 1

IND, 60

GBP, 100

];

Then change your expression from sum(Amount) to sum(Amount/Factor)

Re: Auto Currency convert

Mahamed_Qlik — Thu, 10 Mar 2016 13:18:17 GMT

Hi Sunny,

It will be static for some time later it may changed.

But thnx for the response.

Re: Auto Currency convert

Mahamed_Qlik — Thu, 10 Mar 2016 13:18:55 GMT

Hi Gysbert,

Thank you for your response.

This the one which i was looking for.

Re: Auto Currency convert

Gysbert_Wassenaar — Thu, 10 Mar 2016 13:30:15 GMT

If you're question is answered then please mark this discussion as answered.

Re: Auto Currency convert

Mahamed_Qlik — Thu, 10 Mar 2016 13:30:49 GMT

How do I do that?

Re: Auto Currency convert

sunny_talwar — Thu, 10 Mar 2016 13:31:32 GMT

Look here -> Qlik Community Tip: Marking Replies as Correct or Helpful