Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

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

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

1 Solution

Accepted Solutions
sunny_talwar

3 Replies
sunny_talwar

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

helen_pip
Creator III
Creator III
Author

Thanks SunnyT

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

Kind Regards

Helen

sunny_talwar

Awesome