Conversion

[Anonymous]

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

[er_mohit]

Go to this link might be helpful for you

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

[#3]

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.

[Anonymous]

Thank you Mohit

[Anonymous]

Thank you Vishwa. Let me try it out

[er_mohit]

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

[Anonymous]

Ya sure I will do that.

But I am yet to get a solution.

I need to try the solution you gave.