Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor III

Pivot Table

Hi Community,

I'd like to export data from Qlik to excel and i'm using an extension called JSPivotTable which allowed it.

But I have no ability to add columns and for this reason i'm looking for another solutiion.

Why I ask you if you know a way to fulfill my needs


2 Replies
Contributor III

Re: Pivot Table

Hello Fabio,

The possible reason why you may be seeing this is that the custom extension you are using may not allow an export to excel. Have you considered using the pivot table object which comes directly out of the box with Qlik Sense (from version 2 and above)? The latest version of Qlik Sense does allow export to excel directly from table and pivot table objects.

I hope this answers your question. If so, please mark this as correct and helpful


Re: Pivot Table

Hi Fabio - I agree with Mark in that the extension won't necessary offer export capabilities. In 2.1 (Latest and greatest) you can do a table object export, but the pivot table object export to excel isn't there (only Image,PDF export). You can also get a PPT export from a story slide.  The good news is that the pivot table object -> export to excel capability is coming.

In addition NPrinting will support Qlik Sense and offer all kinds of reporting options.