topic Toggle Between Currency Symbols in QlikView

Toggle Between Currency Symbols

Wed, 09 Jul 2014 13:49:35 GMT

Hi all,

I created three buttons to toggle my money values between USD, GBP, and Brazilian Reals. Each button sets the same variable to the correct currency symbol. I can get the currency symbol to correctly display at the bottom of the chart, but I can't figure out how to have it display on the actual number in my charts (on my bars or in the numbers in my table - notice the discrepancy in the bar chart below). I assume I need to somehow add my currency variable to the number format, but I can't figure out what the syntax is. Any help?

Re: Toggle Between Currency Symbols

Fri, 11 Jul 2014 15:29:23 GMT

Check the attach. It works in desktop view, I didn't check on srv. And the API is described really bad in Qlik. But it's the only way I've found ;-). Good luck!

Re: Toggle Between Currency Symbols

Tue, 15 Jul 2014 06:47:05 GMT

If the problem is solved, please close the topic.

Re: Toggle Between Currency Symbols

Tue, 15 Jul 2014 15:40:07 GMT

I ended up using Money(sum(MyField), '$(vCurrency)#,##0') in my expression, and used "Expression Default" in number format settings. This solves the problem.