Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Qlik Sense - Export data from table object to excel

cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Qlik Sense - Export data from table object to excel

The export functionality of Qlik Sense is designed to only export the data present in the table object to Excel sheet. The color coding which is based on specific conditions in the table object falls under the "properties" of table object which holds good inside Qlik Sense environment and is not compatible with the Excel sheet properties. This being the reason the condition based coloring cannot be exported to excel sheet from table object of Qlik Sense however the data based on the same can be exported. 



Example: 

Steps performed in Qlik Sense: 

1. Create an app in Qlik Sense
2. Drag a table object.
3. Add an expression in "Background color expression" section of intended field. 
4. Example : if ([fieldname]> 0, green(), yellow())
5. When you export the table object to excel, only the data gets exported to excel but the color coding will be lost as it is based on the properties of Qlik Sense product and not compatible with Excel.

 

Resolution:


This is working as designed at this point, however, Qlik has previously received feedback on this feature.  For up to date information and to express your interest in this feature, review Keep formatting on Excel Export .

Tags (1)
Labels (1)
Comments
sofiene_1920
Partner
Partner

Any update please ?? its been 3 years right now

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @sofiene_1920 !

Looks like the Idea is on the Roadmap! And it's got a lot of attention, but it never hurts to lend your voice to it as well: Keep formatting on Excel Export.

 

shloime
Contributor III
Contributor III

You can use the LogiExport extension to achieve this functionality and much more such as adding "selection context" to the file and more.

shloime_0-1631412272652.png

 

Version history
Last update:
2 weeks ago
Updated by: