topic Re: Conversion in QlikView

Conversion

Anonymous — Tue, 30 Apr 2013 09:32:52 GMT

Hi,

I have an issue as below:

I have a currency table whose exchange rates for all in EUR.

Now in one of my application I am getting data in USD for when I view the application in USD it is not showing the correct value. As the currency rate is stored in EUR for USD.

Is there any solution to overcome with this.???

Can we do something in script ??

Please let me knoe if you have any solutions..

Thanks in advance

~Leni

Re: Conversion

er_mohit — Tue, 30 Apr 2013 11:02:42 GMT

Go to this link might be helpful for you

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

Re: Conversion

Tue, 30 Apr 2013 11:16:00 GMT

TRY THIS

One approach to a dynamic currency format is to build a table:

Currencies:
LOAD * INLINE [
Currency: Currency Format
RUB: #,##0.00 Rubles;(#,##0.00 Rubles)
USD: $#,##0.00;($#,##0.00)
EUR: €#,##0.00;(€#,##0.00)
] (delimiter is ':');

Then just use num(...,"Currency Format") anywhere you need the dynamic format. This should work in most places, but doesn't work in a straight table.

Re: Conversion

Anonymous — Thu, 02 May 2013 06:32:51 GMT

Thank you Mohit

Re: Conversion

Anonymous — Thu, 02 May 2013 06:33:21 GMT

Thank you Vishwa. Let me try it out

Re: Conversion

er_mohit — Thu, 02 May 2013 07:07:33 GMT

if your question is resolved then you have might to give either correct or helpful answer to closed this thread.

so that it might be helpful for other developers

Regards

Mohit

Re: Conversion

Anonymous — Thu, 02 May 2013 07:28:45 GMT

Ya sure I will do that.

But I am yet to get a solution.

I need to try the solution you gave.