Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Exporting Pivot Table as it is.

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.

Tags (3)
5 Replies
Highlighted
zturaiki
New Contributor III

Re: Exporting Pivot Table as it is.

- right click on the table

- click on copy to clipboard

- click on Full table

Try it , sure it will help you ...

Highlighted
Not applicable

Re: Exporting Pivot Table as it is.

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?

Highlighted
vikasgupta
Contributor

Re: Exporting Pivot Table as it is.

Hi

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

Highlighted
vikasgupta
Contributor

Re: Exporting Pivot Table as it is.

Hi

find the attached sample for same !!!!

Thanks

Vikas

Highlighted
Not applicable

Re: Exporting Pivot Table as it is.

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