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

Forecasting the sales

Hello ,i need help in writing a expression ,let say i got data

Item       month             spend

A             Jan                 1000

A              Feb                 500

A              Mar                 1500

B              Jan                 2000

B             Feb                    0

B              Mar                 1000

According to above table A had spend 1000 every month on averages so  for the rest of months on Average he will spend 9000

so i need to Estimated spend value for balance period for that year which is Apr, May June........Dec

which results like this for

item               spend

A                      9000

B                       9000

Thanks

Naveen Kumar Kunuru

2 Replies
Not applicable

Go to Axis tab- forecast (it will take only number) and in the expression tab tick the average option....

Anonymous
Not applicable

Hi Naveen,

Take Item in Dimension and expression as follows

=aggr(Sum (spend), Item),

=aggr(sum(spend), month) // if u want each month total spent, if u want avg use avg instead of sum

It will show all Items total Sales, if u want u can use different aggr functions.

Thanks

Pavan