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.