Discussion Board for collaboration on QlikView Layout & Visualizations.
Can anyone help me in exporting a Pivot Table as it is. I mean, with the cells merged for each dimension values.
- right click on the table
- click on copy to clipboard
- click on Full table
Try it , sure it will help you ...
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?
Try this macro using one button you will get in excel same format :
strDate = Year(Date()) &"-"& month(date()) &"-"& Day(Date())
find the attached sample for same !!!!
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...