Qlik Community

Qlik Sense App Development

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

kunkumnaveen
Contributor III

predicting the sales in qlik sense

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

1 Reply
kunkumnaveen
Contributor III

Re: predicting the sales in qlik sense

Any Suggestion how to achieve this task please