Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sandhye1
New Contributor

Pivot table export to excel

Hi all,

         I am trying to export the Pivot table from Qlik Sense to the excel but I see the merged cells in the export. Is there any way to remove the merged cells and export the data. Please help

4 Replies
ogster1974
Honored Contributor II

Re: Pivot table export to excel

Not using the standard export functionality from Qlik Sense.  You export the data as is.

If you want more control over how you format your exports from Qlik then look at NPrinting.

Regards

Andy

mihai_iov
Contributor

Re: Pivot table export to excel

Can you share the exported excel file? Can't really visualize the problem without an example.

Alternatively, you could try to export the pivot table using a macro and attach the said macro to a button

agigliotti
Honored Contributor II

Re: Pivot table export to excel

There is not macro in Qlik Sense.

mihai_iov
Contributor

Re: Pivot table export to excel

My bad. For a second I thought it was QlikView not QlikSense

Community Browser