Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

Predicting sales for upcoming months

hi,this requirement is in Qliksense

if i got three month of sales for a particular item so how can i predict  avg  sales for the remaining and upcoming months i mean for Apr,May,June ........Dec  for each item

Item       month             sales

A             Jan                 1000

A              Feb                 500

A              Mar                 1500

B              Jan                 2000

B             Feb                    0

B              Mar                 1000

month(i have value till dec)

Jan

Feb

Mar

Apr

May

June

.

.

.till

Dec

in Qliksense i took

bar chart or combo chart

Dimension : month

Expression

1)sum(sales)

2)What Kind of Expression should i need to write to get avg line or bar for rest of months

thanks

naveen

2 Replies
OmarBenSalem

Try :

if(SUM(sales),SUM(sales), linest_m(total aggr(if(SUM(sales),SUM(sales)),month),month)*

only(month) +linest_b(total aggr(if(SUM(sales),SUM(sales)),month),month))

SteveNewman
Employee
Employee

‌Similar to omarbensalem recommendation, I created a simple app that shows how to do this in Qlik Sense in a couple of different ways. It can be accessed here:

https://github.com/newmans99/Forecast-Sampler