Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rolling N Period

Hi,

I am new to Qlik sense, and have a requirement I need to try and fill.

For some pivots and graphs I need to be able to show rolling figures, but each column in the pivot is like

May-14 to Apr-15 | Jun-14 to May-15

How do I achieve this?

I cannot provide a data set unfortunately, however I think i would be able to translate from something generic.

I have a datetimefield and a measure already.

Thanks

Gav

2 Replies
consenit
Partner - Creator II
Partner - Creator II

Hi there.

This is a must-read resource on the subject:

Calculating rolling n-period totals, averages or other aggregations

Regards,

Ernesto

rupamjyotidas
Specialist
Specialist