Export data to excel from table does not maintain custom format defined at script level/expression/measure when number formatting sets to AUTO

[Andre_Sostizzo]

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:

• Qlik Sense Enterprise on Windows  
• Qlik Sense Business  
• Qlik Cloud  

[shlomoh]

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/