Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI everyone,
When I export a pivot table from QLIK VIEW I get an export similar to this. I like it!
2016 Spring | 2016 Fall | ||
---|---|---|---|
Sales Rep | Products | QTY | QTY |
Barney Gumble | Beer Can Jacket | 1000 | 1200 |
Barney Gumble | T-Shirts | 25 | 15 |
Prince | Smokin' Jacket | 15 | 100 |
Prince | Batman Album | 11 | 4100 |
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 Spring | 2016 Fall | ||
---|---|---|---|
Sales Rep | Products | QTY | QTY |
Barney Gumble | Beer Can Jacket | 1000 | 1200 |
T-Shirts | 25 | 15 | |
Prince | Smokin' Jacket | 15 | 100 |
Batman Album | 11 | 4100 |
Does anyone know how to configure QLIK Sense exports to do this?
Thanks,
Ralph
Have you come right with this? Please assist
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.