Pivot table export to excel

[Anonymous]

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

[ogster1974]

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

[Anonymous]

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]

There is not macro in Qlik Sense.

[Anonymous]

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