topic Re: Re: Currency Conversion in QlikView

Currency Conversion

Tue, 21 Jan 2014 05:56:12 GMT

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

Re: Currency Conversion

Siva_Sankar — Tue, 21 Jan 2014 06:05:15 GMT

Refer this thread.

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

Regards.

siva

Re: Currency Conversion

sujeetsingh — Tue, 21 Jan 2014 06:14:05 GMT

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

Re: Currency Conversion

Tue, 21 Jan 2014 09:27:46 GMT

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

Re: Currency Conversion

Wed, 22 Jan 2014 06:42:09 GMT

Hi all,

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

Regards,

keerthi

Re: Currency Conversion

tresB — Wed, 22 Jan 2014 06:50:52 GMT

Try this:

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

Re: Re: Currency Conversion

Wed, 22 Jan 2014 07:11:59 GMT

Hi,

Please find the attached file.

Re: Currency Conversion

Wed, 22 Jan 2014 07:12:45 GMT

Hi Tresesco,

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

Thanks & Regards,
keerthi

Re: Currency Conversion

tresB — Wed, 22 Jan 2014 07:14:53 GMT

In text box, try

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

Re: Currency Conversion

Wed, 22 Jan 2014 07:23:23 GMT

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

Re: Currency Conversion

Wed, 22 Jan 2014 07:30:46 GMT

Hi arun,

I want only one currency and the latest date.

By default without selection it should display the amount in GBP based on the latest date.

When i select any currency it should get multiplied with the conversion for the latest dates

Re: Re: Currency Conversion

tresB — Wed, 22 Jan 2014 07:41:40 GMT

May be like this?

PFA

Re: Re: Currency Conversion

Wed, 22 Jan 2014 08:17:00 GMT

Hi,

Please find the attached solution.

Let me know if not correct.

Re: Currency Conversion

Wed, 22 Jan 2014 08:47:47 GMT

Thanks a lot Arun. This is what i wanted.

Could you please explain this

Thanks & Regards,

keerthi

Re: Currency Conversion

Wed, 22 Jan 2014 08:50:43 GMT

Thanks a lot Tresesco Thanks for your valuable time

Re: Currency Conversion

Wed, 22 Jan 2014 08:59:37 GMT

Hi,

In dimension i have used this as calculated dimension.

Aggr(MaxString(DateConversion),Currency1)

For every currency, it will give you maximum date value.

In you data example , datas are in form of string as it was inline data.

In real dates, you should use max() instead of maxstring().

Like this:

Aggr(Max(DateConversion),Currency1)

Re: Currency Conversion

Wed, 22 Jan 2014 09:02:41 GMT

Hey Arun Goel, Could you please explain how it works. I didnt understand why the FIrstSortedValue() is used in the expression.

Re: Currency Conversion

Wed, 22 Jan 2014 09:16:05 GMT

hi,

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

It will sort the Conversion value according to DateConversion and will return first value.

By default, it returns value with lowest weight,

But id we get get value with max sort weight by reversing the sign.

Re: Currency Conversion

Wed, 22 Jan 2014 09:17:46 GMT

By the way, the Arun Goel you mensioned, was not real me...;)..this is my account...

Re: Currency Conversion

Wed, 22 Jan 2014 09:33:17 GMT

Thanks Arun.