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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Keep Pivot Table formatting when exporting to Excel

Hi, I am wanted to export my pivot table exactly how I see it in Qlik. I have attached an example of what is happening. I only want the headings and sub heading field names to appear once and not populated on every single row, please see attached document for example.

Labels (1)
1 Reply
paola_valenti
Creator
Creator

I can extract in that way only using a macro. Does it suit for you?