Discussion Board for collaboration on QlikView Scripting.
I need the sum values please for the next 3 months from last year based on today's date
So, we are November 2018, my model should then pick December 2017, Jan 2018, Feb 2018 figures, Sum these up and i need the total for forecast budgeting
Date Quantity'..30/10/2017 4010/11/2017 9015/12/2017 5015/01/2018 3025/01/2018 7021/02/2018 2025/02/2018 1027/02/2018 6013/03/2018 30....
So if i reload the model now, The model should give me a total of 240 [ Dec 2017 + Jan 2018 + Feb 2018 ]
I want this figure to be column where the calculation is done in SQL section please not on the object
It would be sthing like:
Try Creating Month-Year field in your script and then use it in your presentation layer for calculation.