Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT

Keep formatting on Excel Export

jheasley
Luminary Alumni
Luminary Alumni

Keep formatting on Excel Export

When exporting a table or pivot table, the cell and value colors should be preserved.  End users develop specifications for how to color these based on operational conditions, and often make selections based on these.  The formatting is a critical part of the actionable insights. 

51 Comments
jaishree_Qlik
Partner - Contributor III
Partner - Contributor III

Does this issue still exist in August 2022 version ?

Meghann_MacDonald

Hi @Trick17 , there are a few ideas open regarding preserving pivot table functionalities on export. 

 

stijn_verhoeff
Partner - Contributor III
Partner - Contributor III

@Meghann_MacDonald can you provide some indication with regard to the time frame in which we could expect the 'export with formatting' functionality for Pivot Tables?

It has been a welcome addition to Straight Tables, to be sure, but my client makes frequent use of heatmaps in Pivot Tables. Having to manually reconstruct the same tables as Straight Tables only to be able to export them with formatting is less than ideal. 

Andrew_Kruger
Employee
Employee

Hi @stijn_verhoeff  - there is no timeline to add formatting support of Pivot Tables on QSEoW. 

As an FYI you will find formatting support on Qlik Cloud for the pivot table using the background color expression field.  

stijn_verhoeff
Partner - Contributor III
Partner - Contributor III

@Andrew_Kruger thanks for your quick response! The fact that this does work on Qlik Cloud is good to know. 

I'm not sure how easy this is to port to QSEoW, but I would like to confirm that there is still a real and current need for this functionality on enterprise for the foreseeable future. 

oli_hardy
Partner - Contributor II
Partner - Contributor II

Also in our clients environment this is still a need for QSEoW! 

 

JoergZ
Contributor
Contributor

This is a very important feature - needed many times

cotiso_hanganu
Partner - Creator III
Partner - Creator III

NEEDED in 3 or 4  different projects RIGHT NOW !

 

INCLUDING DYNAMIC NUM FORMATTING !

(THERE ARE ALREADY 10 THREADS IN COMMUNITY LEFT WITHOUT THE REAL ANSWER)

Support_bi
Contributor
Contributor

Qlik don't care about QSEoW anymore, just like NPrinting

cotiso_hanganu
Partner - Creator III
Partner - Creator III

Problem is both in QSEoW and SaaS