How to Rolling sum on Qlik Sense

[redray82]

Hi … I am just beginner for qlik sense..

I would like to add some explression for 3month rolling count & sum in below expression..

there is date field (Fiscal year) which contain "2014-07-01" like this..

could you please add 3month rolling count & sum expression?

• count({$<[Proudcts group]={'DE'},[Code group]={'PE'}>}[Code group])/Sum({$<[Shipping Proudcts group]={'DE'}>}[Q'ty])

Thank you.

[robert99]

Hi

Have a look at this blog post

https://community.qlik.com/t5/Qlik-Design-Blog/Relative-Calendar-Fields/ba-p/1473620

[redray82]

Thank you for your reply!

But i am an beginner for qlik sense and if you could make formula for this, it will be helpful to me..

(its very complicated with adding some expression for me )

[robert99]

Did you read the article I linked. including the beginning

Relative Calendar Fields

A common question in the QlikCommunity forum is how to show only the last N months. The suggested answers are most of the time relatively complex set analysis expressions including dollar expansions with aggregation functions, e.g.

  Sum( {$<Date={">=$(=MonthStart(AddMonths(Max(Date),-12)))<$(=MonthEnd(Max(Date)))"}>} Sales)

 Such an expression may work fine. However, it is not simple. When seen by someone who didn't write it, it is almost incomprehensible.

[robert99]

A common question in the QlikCommunity forum is how to show only the last N months. The suggested answers are most of the time relatively complex set analysis expressions including dollar expansions with aggregation functions, e.g.

  Sum( {$<Date={">=$(=MonthStart(AddMonths(Max(Date),-12)))<$(=MonthEnd(Max(Date)))"}>} Sales)

 Such an expression may work fine. However, it is not simple. When seen by someone who didn't write it, it is almost incomprehensible.

[robert99]

and if you have used data  manager the automatic script creates the required field "MonthsAgo" etc anyway

So if you open the Date field it should have all the sub fields linked to the date field that you need

[Anil_Babu_Samineni]

Try this?

count({$<[Fiscal year] = {">=$(=AddMonths(Max([Fiscal year])),-3)<$(=Max([Fiscal year]))"}, [Proudcts group]={'DE'},[Code group]={'PE'}>}[Code group])/Sum({$<[Fiscal year] = {">=$(=AddMonths(Max([Fiscal year])),-3)<$(=Max([Fiscal year]))"},[Shipping Proudcts group]={'DE'}>}[Q'ty])