Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
alex-wb
Contributor III
Contributor III

Cumulative Rolling Months

Hi All,

I am looking to create a 24 month reporting period where the date behind each month is the sum of the current month and the preceding 11 month. This 24 month period will roll each month, with the last month dropping off.  So for example, month one is October-2018 and is backed by  Nov 2017- October 2018 data, and September 2018 is back by August 2017- October 2018 data and so on so forth.  

I have managed to get the rolling period working for the most recent 12 period. However, I cant get rid of the rest of the axis, and also I would prefer to show it like the second screenshot attachment where I have a current RYTD(first 1-12 months) vs the pervious RYTD(13-24  months).

Attached is a sample of data to show how the file looks that I have used. It's completely fictitious. Where I have order Id it would usually be a  distinct code but I have replaced it with a single letter that is duplicated. 

My data load can be seen in the third screen shot. 

The code I have so far which has generated the first screenshot is as follows:

RangeSum(Above(Aggr(count(OrderNo),RMonthYear),0,12))*AVG({< Day_Ordered = {"$(='>' & Date(AddMonths(Max(Day_Ordered),-12))& '<=' & Date(AddMonths(Max(Day_Ordered),0)))"}>}1)

Thanks for the help, I've been stuck on this for ages. 

 

alexwb_1-1636739926584.png

alexwb_2-1636739942234.png

alexwb_3-1636740400723.png

 

 

 

13 Replies
vinieme12
Champion III
Champion III

Edit and run script without the nested functions and see yourself what each nested function does

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
alex-wb
Contributor III
Contributor III
Author

@vinieme12  What are the nested functions? I guess if I run the each line individually in the debug script that will work as well?

ava121
Contributor
Contributor

Fieldvalue() deals with the field which is put away as a rundown of one of a kind qualities in-memory rather than the table columns which is the reason it is quicker.

Len(field esteem) returns the quantity of special qualities in the field.

The while circle essentially circles through the special qualities from and Autotgenerate 11 makes 11 lines for every extraordinary worth.

Recno() is just a record count

Regards,

getmyoffer.capitalone.com reservation

doubleyourline.com

getmyoffer capital one 

www.mybalancenow.com

getmyoffer.capitalone.com – application

www.indigoapply.com