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

Qlik Sense exports the numbers from a column into text to Excel

0% helpful (0/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Qlik Sense exports the numbers from a column into text to Excel

Last Update:

May 10, 2022 3:23:50 PM

Updated By:

Jamie_Gregory

Created date:

May 22, 2018 6:09:17 AM

When we have data in a table in Qlik Sense and we try to export into excel, some columns that have numbers are exported as a text.?

  • Qlik Sense all versions

 

Cause:

 

  1. The incorrect format in the source files or source data.
  2. Sometimes the Qlik Sense the table object has columns from different source tables that have related data. One thing to lookup is that one of these tables can have records that are not corresponding records on the other table. And at the moment of using set analysis (a sum expression), Qlik sense can represent the "null" values in the frontend as "0" but the number formatting will be "Auto" for that column if we export this most likely will be exported and represented as a "General" format in Excel.



For assistance with Qlik Sense design and development, and much more, join Qlik community; Connect and learn from over 80.000 active users, find answers, and discover best practices and tips and tricks.
 

Resolution:

 

Data source format

 

Verify that the data source has the correct format set for the data

 

Data format in Sense object

 

Change the format in the object you are exporting from to the correct value

  • Select the table you want to export
  • In the "Data" menu select the column with the problem when exporting to excel.
  • Change the value of the Number formatting from "Auto" to "Number", "Money" (Depending if it's currency or money format) or "Custom" and apply the desired format pattern.
  • Press on "Done" 

 

User-added image
Tags (1)
Labels (1)
Comments
cotiso_hanganu
Partner - Creator III
Partner - Creator III

The main problem (5 years later!) is that Auto formating is exporting as text, regardless the actual dynamic formating controlled by num function has !

Version history
Last update:
‎2022-05-10 03:23 PM
Updated by: