Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mariamovasheli
New Contributor III

Rolling 3 Month

Hi, I need to calculate growth rate of sales compere last 3 month to previous 3 month.

I don't Have Date field I only have Month and year. How to calculate Certain period of month? like between last 6 and 3 month and e.t

4 Replies
isingh30
Contributor III

Re: Rolling 3 Month

Can you share your data or sample application?

Thanks.

vkish16161
Contributor III

Re: Rolling 3 Month

You can use the monthstart function and create a month start date.

You can use this date for your rolling calculations.

Find the resources to create a rolling calculation here: The As-Of Table

MVP
MVP

Re: Rolling 3 Month

You can find different methods to calculate the rolling n-months in this post

Calculating rolling n-period totals, averages o... | Qlik Community

mariamovasheli
New Contributor III

Re: Rolling 3 Month

It Is Really helpful Thank You Very Much

Community Browser