When we try to export the data into excel, format of data in excel is not coming as defined at script/expression(or)measure and number formatting sets to AUTO.
Also see Excel Export in Qlik Sense doesn't respect Number FormatFor Example:1
. Load below INLINE data in Qlik Sense application and reloadLOAD * Inline
. Create a table with expression by defining custom format and setting number formatting to AUTO.NUM(Sum(Sales),'###,#0.0 $')Please note
: Same issue occurs if we set number formatting to custom or measure expression.
3. Export data to excel:Environment:
- Qlik Sense, all editions, all versions
User has to define the number format manually from property panel except auto/custom/measure expression to get same format that displays in Qlik Sense chart, in excel upon export.