Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-02-28 11:09 AM

Forecasting Next 6 Months of Items Sold

Hello All

We have created a table which groups Total Items Sold by Month/Year and Stock Code - as demonstrated in the below table. However, we now want to use this historical data to calculate a forecast for the next 6 months of Total Items Sold by generating the values at the script level.

We already have a formula for forecasting but we're open to alternatives - an example of this formula is provided below - with March 2018 being an example of a future month at the time of writing. But I'm not entirely sure how to achieve this in Qlik Script:

  • (March 2018) * ((Feb 2018 + Jan 2018 + Dec 2017 + Nov 2017 + Oct 2017 + Sep 2017) / (Feb 2017 + Jan 2017 + Dec 2016 + Nov 2016 + Oct 2016 + Sep 2016))

MonthYearStockCodeTotalItems
01-2017JEEZ-784325
02-2017JEEZ-784356
03-2017JEEZ-784366
04-2017JEEZ-784315
05-2017JEEZ-78439
06-2017JEEZ-78438
07-2017JEEZ-78436
08-2017JEEZ-78438
09-2017JEEZ-784310
10-2017JEEZ-784319
11-2017JEEZ-784322
12-2017JEEZ-784335
01-2018JEEZ-784332

What is the best scripting solution to get this result, please? Any advice would be great.

1,322 Views
0 Likes
4 Replies
pablolabbe
Luminary Alumni
Luminary Alumni
‎2018-02-28 12:41 PM

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others

1,127 Views
0 Likes
Anonymous
Not applicable
‎2018-03-02 05:02 AM
Author

In response to sunny_talwar

Thanks Sunny From my understanding of Linest_M and Linest_B it's used to plot graph values? Ideally, in the load-script, I want to continue the table as shown in the original post to include the next 6 months in the future using previous records. Instead of trying to plot the trend within a chart object.

1,127 Views
0 Likes
zebhashmi
Specialist
Specialist
‎2018-03-02 08:47 AM

I would say creat a factor Field for first next mount and then Second next month ... by residence load

1,127 Views