Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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