Auto Currency convert

[Mahamed_Qlik]

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

[sunny_talwar]

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

[Gysbert_Wassenaar · Accepted solution]

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)

[Mahamed_Qlik]

Hi Sunny,

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

But thnx for the response.

[Mahamed_Qlik]

Hi Gysbert,

Thank you for your response.

This the one which i was looking for.

[Gysbert_Wassenaar]

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

[Mahamed_Qlik]

How do I do that?

[sunny_talwar]

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