topic Re: Exporting Pivot Table as it is. in QlikView

Exporting Pivot Table as it is.

Fri, 08 Mar 2013 10:08:55 GMT

Hi,

Can anyone help me in exporting a Pivot Table as it is. I mean, with the cells merged for each dimension values.

Thanks.

Br,

Prasanna.

zturaiki — Fri, 08 Mar 2013 12:50:07 GMT

- right click on the table

- click on copy to clipboard

- click on Full table

Try it , sure it will help you ...

Mon, 11 Mar 2013 05:20:49 GMT

Yeah...that helps...but is there a more elegant way were the users can just hit a button and export the table with the pivoting?

vikasgupta — Mon, 11 Mar 2013 05:56:59 GMT

Try this macro using one button you will get in excel same format :

Sub SendReport

ActiveDocument.Sheets("SH01").Activate

'ActiveDocument.reload

set objExcel=ActiveDocument.GetSheetObject("CH01")

strDate = Year(Date()) &"-"& month(date()) &"-"& Day(Date())

filepath="D:\Excel_"&strDate&".xls"

objExcel.ExportBiff filepath

ActiveDocument.GetApplication.Sleep 5000

Thanks

Vikas

vikasgupta — Mon, 11 Mar 2013 06:09:48 GMT

find the attached sample for same !!!!

Thanks

Vikas

Wed, 13 Mar 2013 05:36:21 GMT

Hi,

This not wat actually I am looking at.

Wat I wanted was the Cells in the Exported Excel to be grouped to gether as it is in the Pivot Table in Qlikview Client or Accesspoint.

But thx for trying to help...

Br,

Prasanna