Qlik Sense Dynamic Money Format that will export to Excel
I would like to dynamically change the format pattern in a table for the Money Format to show a $ or a different currency symbol depending on the country I select (Euro, etc).
In addition I need to be able to export the numbers to Excel without any format problems. If I use AUTO with a custom format the Export to Excel does not work (Number Stored as Text is displayed and I need to manually adjust the data).
I am open for any suggestions. I am using Qlik Sense Feb 2019.