Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

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

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Andre_Sostizzo
Digital Support
Digital Support

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

Last Update:

May 10, 2022 3:23:50 PM

Updated By:

Jamie_Gregory

Created date:

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.

Custom format sets at expression NUM.png


3. Export data to excel:

NUM Sales Excel.png


Environment:

Tags (1)
Labels (2)
Comments
shlomoh
Contributor III
Contributor III
Version history
Last update:
‎2022-05-10 03:23 PM
Updated by: