0 Replies Latest reply: May 16, 2016 4:29 AM by Nick Gates RSS

    NPrinting Cell Reference Problems

    Nick Gates

      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.