Skip to main content

Suggest an Idea

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

Announcements
NEW Customer Portal: Initial launch will improve how you submit Support Cases. FIND OUT MORE

Export pivot table to Excel in straight format (as it it in QlikView)

simospa
Partner - Specialist
Partner - Specialist

Export pivot table to Excel in straight format (as it it in QlikView)

Exporting a pivot table to Excel, the result is a table "pivot" style, with merged fields as we can see in Sense

Sense.png

But... for many years our Qlik customers working with QlikView could export a pivot into straight format...

QlikView.png

Why now it is no more possible? It's a very important feature from my point of view because for years we encouraging users to have that type of export and the users want that.

Please vote 🙂

Thank you in advance.

Simone

 

6 Comments
Andrew_Kruger
Employee
Employee
 
Status changed to: Open - Not Planned
Chrysostomos
Partner - Contributor II
Partner - Contributor II

You have two options…

The first one is to wait Qlik to launch any update resolving this issue

 

The second one is to try KlikSheet which is the ultimate solution to embed a spreadsheet within Qlik ecosystem.

By using KlikSheet any data from a Qlik object can be exported to a spreadsheet into a straight format. On top of that, you can use these data to create your own analytics on a spreadsheet environment without losing any interaction with Qlik.

vasilev
Creator
Creator

Hello Qlik team,

I am missing also this export behaviour. It would be grateful, if you implement this feature in the in the near future.

 

BR,

Rumen

maalexan
Contributor
Contributor

Hello Qlik team,

we would be greatful if you could add this feature soon - it would make the user experience much better. Otherwise we have to work with straight tables in order to export data unmerged (or unmerge it in the excel).

Thanks and BR

Alex 

davidhillier
Contributor
Contributor

Dear all,

I also think that this feature is a must have for our users. Please add it as a possibilitity! Thank you! 

BR

David

Meghann_MacDonald

Hi, this is a duplicate of Pivot Table Export - Merged Values for Dimensions and Total Rows #274575. Please open the ideation portal and search for 274575 to add your vote there. This was also suggested here: Export pivot tables to excel format

Status changed to: Closed - Duplicate