Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

Is it possible to load/read the pivot table?

Hi,

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
oknotsen
Master III
Master III

Could you show an example of what you mean?

May you live in interesting times!
Not applicable
Author

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
Author

Can you guide me @Onno van Knotsenburg ?

settu_periasamy

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)

Or,

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
Author

Hi,

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