topic Re: Problem with excel template pages and creating pivot tables from Sense straight tables in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/Problem-with-excel-template-pages-and-creating-pivot-tables-from/m-p/1429281#M20388 <HTML><HEAD></HEAD><BODY><P>Ah, so it was just fixed and I need to upgrade. Thanks!</P></BODY></HTML> Thu, 07 Dec 2017 07:07:36 GMT Anonymous 2017-12-07T07:07:36Z Problem with excel template pages and creating pivot tables from Sense straight tables https://community.qlik.com/t5/Qlik-NPrinting/Problem-with-excel-template-pages-and-creating-pivot-tables-from/m-p/1429279#M20386 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have somewhat succesfully implemented my Qlik Sense pivot tables into Nprinting reports developed on an excel template by following the method that has been described for example here: <A href="https://community.qlik.com/docs/DOC-13947">How to Create an Excel PivotTable Report</A>.</P><P></P><P>However, I run into trouble when I try to loop the report through all the values of a dimension (costcenter) with the "Page" feature: all of the pivot tables look exactly the same, i.e. they don't loop through the dimension I have set as the page. To be more precise, all of the pivots on all of the pages use the very first value of the costcenter dimension. All the other objects, formulas etc. on the page work just fine. Even the straight tables that provide the data for the pivots are looping properly from page to page.</P><P></P><P>From looking at the xlsx preview, the problem seems to be that the pivot tables from each page are referring to the same table from the first page as the data source. Hence the figures for the first costcenter come up on all of the pivot tables.</P><P></P><P>I've tried to think of a workaround to make the source dynamic but haven't come up with anything yet. </P><P></P><P>Any ideas would be much appreciated.</P><P></P><P>Regards,</P><P>Niko</P></BODY></HTML> Tue, 05 Dec 2017 11:27:25 GMT https://community.qlik.com/t5/Qlik-NPrinting/Problem-with-excel-template-pages-and-creating-pivot-tables-from/m-p/1429279#M20386 Anonymous 2017-12-05T11:27:25Z Re: Problem with excel template pages and creating pivot tables from Sense straight tables https://community.qlik.com/t5/Qlik-NPrinting/Problem-with-excel-template-pages-and-creating-pivot-tables-from/m-p/1429280#M20387 <HTML><HEAD></HEAD><BODY><P>Hi, November 2017 release notes says:</P><P></P><P><EM>Excel pivot tables are supported with Page feature</EM></P><P><EM>Jira issue ID: OP-5657</EM></P><P><EM>You can now create Excel pivot tables and straight tables inside worksheets with the Qlik NPrinting</EM></P><P><EM>Page feature activated. Excel pivot tables must be created in the same worksheet as the table that</EM></P><P><EM>contains the source data.</EM></P><P><EM><BR /></EM></P><P>Wich version are you using?</P><P></P><P>Regards</P><P></P><P>CS</P></BODY></HTML> Wed, 06 Dec 2017 12:18:48 GMT https://community.qlik.com/t5/Qlik-NPrinting/Problem-with-excel-template-pages-and-creating-pivot-tables-from/m-p/1429280#M20387 silvacarlos 2017-12-06T12:18:48Z Re: Problem with excel template pages and creating pivot tables from Sense straight tables https://community.qlik.com/t5/Qlik-NPrinting/Problem-with-excel-template-pages-and-creating-pivot-tables-from/m-p/1429281#M20388 <HTML><HEAD></HEAD><BODY><P>Ah, so it was just fixed and I need to upgrade. Thanks!</P></BODY></HTML> Thu, 07 Dec 2017 07:07:36 GMT https://community.qlik.com/t5/Qlik-NPrinting/Problem-with-excel-template-pages-and-creating-pivot-tables-from/m-p/1429281#M20388 Anonymous 2017-12-07T07:07:36Z