Currency Conversion

[#1]

Hi All,

I have the dashboard with amount showing in GBP. I want to convert into USD, INR or any other currencies based on the conversion rate.

I will be getting the conversion rate from the database on a day to day basis.

Please  help me with this how to change the currency.

I have attached the QVW. Please have look into it.

Thanks in Regards,

Keerthi

[Siva_Sankar]

Refer this thread.

http://community.qlik.com/thread/14809

Regards.

siva

[sujeetsingh]

On the number tab of Properties you can set it what ever you want

[#4]

HI all,

I worked on it. But when i have two values for EUR we have to take latest dates(Max date) conversion rate, how do i take MAX of a date.

I want to display only for one latest date for each currency.

Please help me with this.

Regards,

Keerthi

[#5]

Hi all,

Please tell me how to filter the data in this scenario???

Regards,

keerthi

[tresB]

Try this:

=Sum([Amount Approved])* FirstSortedValue(Conversion,-Date#(DateConversion,'DD-MM-YYYY'))

[#7 · Accepted solution]

Hi,

Please find the attached file.

[#8]

Hi Tresesco,

When i select EUR it showing two values. I want only the latest dates conversion rate to be displayed.

Thanks & Regards,
keerthi

[tresB]

In text box, try

= FirstSortedValue(Conversion,-Date#(DateConversion,'DD-MM-YYYY')

[#10]

When i select EUR i am getting two dates i want only one date