topic Re: As Of-Table in QlikView

As Of-Table

Anonymous — Wed, 25 Nov 2015 18:22:15 GMT

Current Rolling 12 should be calculated as follows using the As Of-Table:

Sum({$<MonthDiff={"<12"}>} Sales)

How does one calculate last year rolling 12 months using As Of-Table?

Re: As Of-Table

swuehl — Wed, 25 Nov 2015 18:51:51 GMT

If you are following The As-Of Table,

{<MonthDiff = {"<12"}>} is filtering Rolling 12 for the current year only.

Create a chart with AsOfMonth as dimension and

Sum({$<MonthDiff={"<12"}>} Sales)

as expression.

You should see a Rolling 12 Month accumulation also for last year, assuming you have enough data for the historic accumulation.

Re: As Of-Table

Anonymous — Wed, 25 Nov 2015 19:11:54 GMT

Swuehl

Thank you very much for your prompt response, most appreciated.

Yes i can see a Rolling 12 Month accumulation with all historical information. However, i wanted a separate chart for each year so that one can compare current Rolling 12 Months versus last year Rolling 12 Months. Can this be done and if so how?

Regards.