Discussion Board for collaboration on QlikView Scripting.
Trying to achieve the result table in the illustration below:
essentially i'm after a YTD total for each Date in the Sales table. The From and to dates are defined in the YTDMap table.
I have tried various methods including the use of IntervalMatch but cant seem to get the correct totals.
I have attached a QVW with the inline tables.
Any help would be much appreciated as always.
I can see in your Map table, that for each date you want to accumulate last 11 months. Am i right?
I reccomend you to use standard accumulation functionality in this case (comm_acc11_thr_114784.qvw).
If you really need interval math, you will find it in v1.qvd
Let me know if that helps