
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Export data to excel from table does not maintain custom format defined at script level/expression/measure when number formatting sets to AUTO
May 10, 2022 3:23:50 PM
Apr 20, 2018 6:14:04 AM
When exporting data to Excel, the data format is Excel does not match the one defined in the script/expression/measure. Number formatting is set to AUTO.
This is working as designed.
To vote on reviewing the behaviour, see Keep formatting on Excel Export for an idea logged to maintain formatting.
Example:
1. Load below INLINE data in Qlik Sense application and reload
LOAD * Inline [ Country,Sales India, 200000 USA,300000 AUS, 400000 NEWZ, 250000 ];
2. Create a table with expression by defining custom format and setting number formatting to AUTO.
NUM(Sum(Sales),'###,#0.0 $')
Please note: The same issue will occur if the number formatting has been set to custom or measure expression.
3. Export data to excel:
Environment:

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Excel export formatting can be achieved using the following extension for QS
https://logiexport.logsys.co.il/documentation/
https://logiexport.logsys.co.il/articles/how-to-easily-control-the-values-formatting/