Toggle Between Currency Symbols

[#1]

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?

[#2]

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!

[#3]

If the problem is solved, please close the topic.

[#4 · Accepted solution]

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