Qlik Community

Qlik Sense App Development

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

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
kunkumnaveen
Valued Contributor

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
Valued Contributor

Re: predicting the sales in qlik sense

Any Suggestion how to achieve this task please