topic Re: Curency Conversion problem in QlikView

Curency Conversion problem

svsudhakar — Wed, 04 Dec 2013 12:49:34 GMT

Hi,

I need help on below issue..

I have created one Finance Dashboard by default Values are showing only INR format. Now I got the requirement like client want to see the values in different currency formats like USD,.......

Please let me know the simple solution to achieve this.

Thanks in Advance....

Regards,

Sudhakar Siram

Re: Curency Conversion problem

Yousef_Amarneh — Wed, 04 Dec 2013 12:59:02 GMT

you have to get a table contains all needed currencies and the rate of each one, then you have to multiply your value with the selected currency, don't make a relation to the currency table in the data model

Re: Curency Conversion problem

svsudhakar — Wed, 04 Dec 2013 13:14:05 GMT

Thanks for your reply Yousef...

my dashboard having so many expressions every thing I have created in variables. we can multiply the conversion value for achieving the required format...but

the challenge is we have currency table it's having month wise Currency rates (USD,SU.....).

Based on month selection and currency(INR,USD...) selection I need to get the Conversion value and this value is multiplied with original value to get the converted value.

Please let me know how to achieve this one..

Re: Curency Conversion problem

svsudhakar — Thu, 05 Dec 2013 07:47:06 GMT

Please find the attached sample QVW file.

Re: Curency Conversion problem

kaushiknsolanki — Thu, 05 Dec 2013 07:49:51 GMT

Hi,

There should be some linkage between the tables, otherwise its hard to know what exchange rate to be applied on the data.

Regards,

Kaushik Solanki

Re: Re: Curency Conversion problem

Alejandro_Hernández — Thu, 05 Dec 2013 07:57:25 GMT

here's an example

Re: Curency Conversion problem

svsudhakar — Thu, 05 Dec 2013 09:23:27 GMT

Hi Alejandro,

attached qvw is working fine as per month selection. But I have Quarter and year calendar fields are also there.

Suppose if we select Quarter or year how will calculate the exchange rate ..

Regards,

Sudhakar Siram