Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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:
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/