https://community.qlik.com/t5/Integration-Extension-APIs/Get-all-pivot-table-data/m-p/1835898#M15573 <P>Hello colleagues!</P><P>I am developing my own pivot table extension. Faced the problem of getting complete data.</P><P>If I create a regular table, then I use the following construction:</P><P>&nbsp;</P><LI-CODE lang="javascript">var qTotalData = []; var totalrow = this.backendApi.getRowCount(), columns = hc.qDimensionInfo.length + hc.qMeasureInfo.length, pageheight = Math.floor(10000 / columns); var lastrow = 0, me = this; this.backendApi.eachDataRow( function ( rownum, row ) { lastrow = rownum; qTotalData.push(row) }); if (totalrow &gt; lastrow + 1) { var requestPage = [{ qTop: lastrow + 1, qLeft: 0, qWidth: columns, qHeight: pageheight }]; this.backendApi.getPivotData( requestPage ).then( function ( dataPages ) { me.paint( $element, layout ); }); }</LI-CODE><P>&nbsp;</P><P>But this method does not work with pivot tables.</P><P>I found that there is a <STRONG>getPivotData method</STRONG>, but I don't know how to use it to get all the data in the pivot table.</P><P>The <STRONG>eachDataRow method</STRONG> does not return anything (does not work as I expected) and I cannot redraw the extension, hence the <EM>lastrow</EM> does not increase.</P><P>&nbsp;</P><P>Any ideas on how to get complete data on a pivot table?</P><P>Thank you in advance for your help</P><P>&nbsp;</P><P>With respect George.</P> Fri, 15 Nov 2024 23:44:39 GMT g_bolshakov 2024-11-15T23:44:39Z https://community.qlik.com/t5/Integration-Extension-APIs/Get-all-pivot-table-data/m-p/1835898#M15573 <P>Hello colleagues!</P><P>I am developing my own pivot table extension. Faced the problem of getting complete data.</P><P>If I create a regular table, then I use the following construction:</P><P>&nbsp;</P><LI-CODE lang="javascript">var qTotalData = []; var totalrow = this.backendApi.getRowCount(), columns = hc.qDimensionInfo.length + hc.qMeasureInfo.length, pageheight = Math.floor(10000 / columns); var lastrow = 0, me = this; this.backendApi.eachDataRow( function ( rownum, row ) { lastrow = rownum; qTotalData.push(row) }); if (totalrow &gt; lastrow + 1) { var requestPage = [{ qTop: lastrow + 1, qLeft: 0, qWidth: columns, qHeight: pageheight }]; this.backendApi.getPivotData( requestPage ).then( function ( dataPages ) { me.paint( $element, layout ); }); }</LI-CODE><P>&nbsp;</P><P>But this method does not work with pivot tables.</P><P>I found that there is a <STRONG>getPivotData method</STRONG>, but I don't know how to use it to get all the data in the pivot table.</P><P>The <STRONG>eachDataRow method</STRONG> does not return anything (does not work as I expected) and I cannot redraw the extension, hence the <EM>lastrow</EM> does not increase.</P><P>&nbsp;</P><P>Any ideas on how to get complete data on a pivot table?</P><P>Thank you in advance for your help</P><P>&nbsp;</P><P>With respect George.</P> Fri, 15 Nov 2024 23:44:39 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Get-all-pivot-table-data/m-p/1835898#M15573 g_bolshakov 2024-11-15T23:44:39Z