Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table Export to Excel - Fill All Columns and Rows

HI everyone,

When I export a pivot table from QLIK VIEW I get an export similar to this.  I like it!



2016 Spring2016 Fall
Sales RepProductsQTYQTY
Barney GumbleBeer Can Jacket10001200
Barney GumbleT-Shirts2515
PrinceSmokin' Jacket15100
PrinceBatman Album114100

However, when I export the same pivot report to Excel from QLIK Sense I get the following.  Column 1 does not get auto filled.



2016 Spring2016 Fall
Sales RepProductsQTYQTY
Barney GumbleBeer Can Jacket10001200
T-Shirts2515
PrinceSmokin' Jacket15100
Batman Album114100

Does anyone know how to configure QLIK Sense exports to do this?

Thanks,

Ralph

2 Replies
KineshR
Contributor
Contributor

Have you come right with this? Please assist

MohasinKhan
Contributor III
Contributor III

Hi, 

In Qliksense unfortunately, there is no option to fill the fields. Reason is, Qliksense pivot table merges the cells.

I also faced this issue, but i have a work around which may help.

Once you download the pivot into excel, select the entire column in excel and click Merge & Center under Home Menu (Alignment) of excel. (See attached screenshot)

Hope it helps.