Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is it possible to load/read the pivot table?


I know it is possible to read the classic pivot table. But is it possible to read the data from the newer version of Pivot Tables, which has all the "ROW LABELS" in a  single column. ?

I don't have the data source for my pivots and all the old files have pivot tables in the new format.

Can you please guide me?

5 Replies
Master III
Master III

Could you show an example of what you mean?

May you live in interesting times!
Not applicable

Screen Shot 2016-04-11 at 11.33.06 pm.pngI don't have MS Excel 2013 at home so can't provide the excel sheet. I can only ( )provide you the link to the image from the internet ! !

Screen Shot 2016-04-11 at 11.33.06 pm.png

Not applicable

Can you guide me @Onno van Knotsenburg ?


When you read this thru QV, It will show the single column for Row Labels.

Have you tried to change the pivot table as Classic Pivot table ? (Not sure in 2013 but check)


In excel pivot table, Double click the Grand Total (380), It will create the data source.

then you can use it as normal Qlikview Load..

Not applicable


The pivot is not longer connected to the database. I am neither able to change to "Classic Pivot table" nor able to "create data source" by double click.

There is a VBA function which Cell.IndentLevel that I am trying to explore to return the indent level. But I am not sure if it would work to re-construct the straight table