topic NPrinting Cell Reference Problems in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-Cell-Reference-Problems/m-p/1151042#M11397 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have recently created an NPrinting Report showing total sales by month and financial year.</P><P></P><P>This has been working perfectly and I had it running on a monthly schedule.</P><P></P><P>My financial year field is derived by a variable set in the loading script.</P><P></P><P>The problem I am facing is that due to the change in financial year, by cell references are now out of sync. </P><P></P><P>For example cell reference 'CitySales 1_14' which previously was my total column, now does not exist. </P><P></P><P>The total column is now 'CitySales 1_3'.</P><P></P><P>Is there a method to get Qlikview to almost auto populate the cells with 0, so there is always data in there to ensure the cell references work?</P><P></P><P>Thanks in advance.</P><P></P><P>Regards</P><P>Jim</P></BODY></HTML> Mon, 16 May 2016 08:29:54 GMT the_murkle_man 2016-05-16T08:29:54Z NPrinting Cell Reference Problems https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-Cell-Reference-Problems/m-p/1151042#M11397 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have recently created an NPrinting Report showing total sales by month and financial year.</P><P></P><P>This has been working perfectly and I had it running on a monthly schedule.</P><P></P><P>My financial year field is derived by a variable set in the loading script.</P><P></P><P>The problem I am facing is that due to the change in financial year, by cell references are now out of sync. </P><P></P><P>For example cell reference 'CitySales 1_14' which previously was my total column, now does not exist. </P><P></P><P>The total column is now 'CitySales 1_3'.</P><P></P><P>Is there a method to get Qlikview to almost auto populate the cells with 0, so there is always data in there to ensure the cell references work?</P><P></P><P>Thanks in advance.</P><P></P><P>Regards</P><P>Jim</P></BODY></HTML> Mon, 16 May 2016 08:29:54 GMT https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-Cell-Reference-Problems/m-p/1151042#M11397 the_murkle_man 2016-05-16T08:29:54Z