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 - Export data from table object to excel

No ratings
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

Last Update:

May 10, 2022 3:23:50 PM

Updated By:

Jamie_Gregory

Created date:

Apr 12, 2018 3:07:53 AM

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 - Contributor III
Partner - Contributor III

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:
‎2022-05-10 03:23 PM
Updated by: