Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exporting to Excel - Pivot Grouping Issue

Hi All,

I want to export a pivot table like the one below, but not have the exported table repeat the Group1 value.

error loading image

error loading image

Instead I want to achieve this result:

error loading image

NOTE: I don't want to use the indent mode, unless you can configure the indent mode to display exactly the above result.

Thanks very much.

2 Replies
hectorgarcia
Partner
Partner

I also want to know how to do it.....

suniljain
Master
Master

Try Following Method



set

"E:\Qlikview\Prima\PPT\Department_Loadinng.xls"

,5

obj = ActiveDocument.GetSheetObject("CH703")