Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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