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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

export to excel

Hello Guys,

Is there any set up for exporting to excel to keep the format and grouping for the pivot tables?

As I see when we export to excel it looses the grouping of the nested rows & columns.

Thanks

2 Replies
m_woolf
Master II
Master II

You would have to write a macro to transform the Excel file to look the way you want it.

Not applicable
Author

I just want to keep as it is in Qlik !

Have any idea?

Thanks