Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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