Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Qlik Sense Dynamic Money Format that will export to Excel

Hello,

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.

Thank  You,

 

Michael

2 Replies
Highlighted
Creator
Creator

Hello Michael,

 

Try to create a measure with conditionals and the num() function.

Something like:

if( Currency='Euro',        num( Sum(value) , ' €#,###') ,  num( Sum(value) , 'US$#,###'))

Regards,

Guilherme

Highlighted
Partner
Partner

I have to use the AUTO format for it to show but then the export to Excel does not work.

I really need the export to Excel to work and allow the users to sum up the numbers.

Thanks,

 

Michael