Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
TSNA
Contributor II
Contributor II

visualizations About the numeric types of downloaded Excel

When I download data from a visualization as Excel, I want to display a specific column as a numeric type, is it possible?

Currently, columns loaded with num are displayed as text in Excel.
Is it possible to display this in num from the beginning in Excel?

Labels (1)
1 Solution

Accepted Solutions
MatheusC
Specialist II
Specialist II

@TSNA 
See the articles below:

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-exports-the-numbers-from-a-column...


https://community.qlik.com/t5/Official-Support-Articles/Export-data-to-excel-from-table-does-not-mai...

In summary, you will need a prior formatting so that the formatting is applied when exporting, and not left as Automatic.


Regarts, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!

View solution in original post

1 Reply
MatheusC
Specialist II
Specialist II

@TSNA 
See the articles below:

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-exports-the-numbers-from-a-column...


https://community.qlik.com/t5/Official-Support-Articles/Export-data-to-excel-from-table-does-not-mai...

In summary, you will need a prior formatting so that the formatting is applied when exporting, and not left as Automatic.


Regarts, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!