Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

IntervalMatch with Rolling YTD total

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.

1 Reply
Not applicable

Re: IntervalMatch with Rolling YTD total

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