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

2 Replies
YoussefBelloum
Esteemed Contributor

Re: Rolling 3 Month

Hi,

yes it is possible to compare a set of months (previous/actual/last... etc) using Month and Year fields.

would you be able to share sample data ?

arvind_patil
Valued Contributor II

Re: Rolling 3 Month

Dear Mariam ,


Please use below code and convert your expression like below.


Sum({<DateField={">=$(=addmonths(max(DateField),-2))<=$(=max(DateField))"},Year=,Month=,Quarter=>}Sales)


Thanks,

Arvind Patil