Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
Partner
Partner

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