Each data point on chart to show a sum of data for 12 month period

[helen_pip]

Dear Qlikview User

I am looking for users to share any examples which I could possibly adapt my data set, as I am unsure how to approach this

I need to create a chart where the X axis would be Month Year and and Y axis be a count of I.e. Attendances

On each data point of the X axis there needs to be a count of attendance for the last 12 months

I.e.

Mar 16 - Shows count of attendances for Feb-15 - Mar-16

Apr 16 - Shows a count of attendances for Mar-15 - Apr-16

May 16 - Shows a count of attendances for Apr-15 - May-16

Does anyone have any examples they could possible share where they have done something similar

Kind Regards

Helen

[sunny_talwar · Accepted solution]

You can use The As-Of Table‌ to do this

[helen_pip]

Thanks SunnyT

I have applied the logic, and believe that it is working for me

Kind Regards

Helen

[sunny_talwar]

Awesome