0 Replies Latest reply: May 16, 2016 4:29 AM by Jim Morrison RSS

    NPrinting Cell Reference Problems

    Jim Morrison

      Hi Guys,

       

      I have recently created an NPrinting Report showing total sales by month and financial year.

       

      This has been working perfectly and I had it running on a monthly schedule.

       

      My financial year field is derived by a variable set in the loading script.

       

      The problem I am facing is that due to the change in financial year, by cell references are now out of sync.

       

      For example cell reference 'CitySales 1_14' which previously was my total column, now does not exist.

       

      The total column is now 'CitySales 1_3'.

       

      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?

       

      Thanks in advance.

       

      Regards

      Jim