Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Loghry14
Contributor
Contributor

Rolling Linest_m function for time series analysis

Hello new here.  I am running into an issue with a unique ask.  I am trying to get a table that has a rolling linest_m for the past n days (lets say 5 for now) to help with smoothing a graph.  Right now I have:

linest_m(aggr((sum([38_1_1])+sum([38_2_1])+sum([38_3_1]))/(sum([35_1_1])+sum([35_2_1])+sum([35_3_1])), YYYYMMDD), YYYYMMDD)

The term (sum([38_1_1])+sum([38_2_1])+sum([38_3_1]))/(sum([35_1_1])+sum([35_2_1])+sum([35_3_1]) is one of our metrics.  This code works if I change the datefield on the table to a weekly or monthly basis; however, it only gives the regression for that week or month.  I am looking to have a daily regression that includes that day and the previous n days.  I have tried using the above function to no avail (could be using it incorrectly).

Ultimately looking to plot this in a graph.  Thanks for your help.

2 Replies
sunny_talwar

Would you be able to provide a sample and the output you expect to see from it?

Loghry14
Contributor
Contributor
Author

Hey Sunny.  I am attaching an excel file.  It is possible to do this in excel, but I like the ability to have the graphs made each day in Qlik Sense for others in our business to use for the time series.  The data is on the far left and I have done 3 different rolling linear regression series (one where n=5, n=10, and n=17)  You can see the graphs start to get smoother and that is what we want.  I can get the regression model in qlik sense from above; however, I can't get it to do a linear model on every 5 data points like I did in excel.  So what I am looking for is to get essentially what I have done in excel to run in Qlik sense if possible.  Thanks