topic Re: Is it possible to load/read the pivot table? in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-read-the-pivot-table/m-p/1088442#M924357 <HTML><HEAD></HEAD><BODY><P>Can you guide me @Onno van Knotsenburg ?</P></BODY></HTML> Wed, 13 Apr 2016 09:15:06 GMT 2016-04-13T09:15:06Z Is it possible to load/read the pivot table? https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-read-the-pivot-table/m-p/1088439#M924354 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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, <SPAN style="font-size: 13.3333px;">which has all the "ROW LABELS" in a&nbsp; single column. </SPAN>?</P><P></P><P>I don't have the data source for my pivots and all the old files have pivot tables in the new format. </P><P></P><P>Can you please guide me?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-read-the-pivot-table/m-p/1088439#M924354 2020-11-25T16:16:04Z Re: Is it possible to load/read the pivot table? https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-read-the-pivot-table/m-p/1088440#M924355 <HTML><HEAD></HEAD><BODY><P>Could you show an example of what you mean?</P></BODY></HTML> Mon, 11 Apr 2016 08:21:20 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-read-the-pivot-table/m-p/1088440#M924355 oknotsen 2016-04-11T08:21:20Z Re: Is it possible to load/read the pivot table? https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-read-the-pivot-table/m-p/1088441#M924356 <HTML><HEAD></HEAD><BODY><P><IMG alt="Screen Shot 2016-04-11 at 11.33.06 pm.png" class="jive-image image-1" src="/legacyfs/online/121231_Screen Shot 2016-04-11 at 11.33.06 pm.png" style="max-width: 620px; height: auto;" />I don't have MS Excel 2013 at home so can't provide the excel sheet. I can only ( <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /> )provide you the link to the image from the internet ! !</P><P></P><P></P><P><IMG alt="Screen Shot 2016-04-11 at 11.33.06 pm.png" class="jive-image image-2" src="/legacyfs/online/121235_Screen Shot 2016-04-11 at 11.33.06 pm.png" style="height: auto;" /></P></BODY></HTML> Mon, 11 Apr 2016 15:40:09 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-read-the-pivot-table/m-p/1088441#M924356 2016-04-11T15:40:09Z Re: Is it possible to load/read the pivot table? https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-read-the-pivot-table/m-p/1088442#M924357 <HTML><HEAD></HEAD><BODY><P>Can you guide me @Onno van Knotsenburg ?</P></BODY></HTML> Wed, 13 Apr 2016 09:15:06 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-read-the-pivot-table/m-p/1088442#M924357 2016-04-13T09:15:06Z Re: Is it possible to load/read the pivot table? https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-read-the-pivot-table/m-p/1088443#M924358 <HTML><HEAD></HEAD><BODY><P>When you read this thru QV, It will show the single column for Row Labels.</P><P></P><P>Have you tried to change the pivot table as Classic Pivot table ? (Not sure in 2013 but check)</P><P>Or,</P><P>In excel pivot table, Double click the Grand Total (380), It will create the data source. </P><P>then you can use it as normal Qlikview Load..</P></BODY></HTML> Wed, 13 Apr 2016 10:26:47 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-read-the-pivot-table/m-p/1088443#M924358 settu_periasamy 2016-04-13T10:26:47Z Re: Is it possible to load/read the pivot table? https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-read-the-pivot-table/m-p/1088444#M924359 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>There is a VBA function which <SPAN class="crayon-v" style="font-size: 12px; font-family: Monaco, MonacoRegular, 'Courier New', monospace; color: #002d7a !important;">Cell</SPAN><SPAN class="crayon-sy" style="font-size: 12px; font-family: Monaco, MonacoRegular, 'Courier New', monospace; color: #333333 !important;">.</SPAN><SPAN class="crayon-i" style="font-size: 12px; font-family: Monaco, MonacoRegular, 'Courier New', monospace; color: #000000;">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</SPAN></P></BODY></HTML> Mon, 18 Apr 2016 02:23:00 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-load-read-the-pivot-table/m-p/1088444#M924359 2016-04-18T02:23:00Z