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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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.

1 Reply
paola_valenti
Creator
Creator

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