Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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: