Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Forecasting

I have a table like such  & the line for the Forecast. I'm wanting to add a month row as well.  How would i incorporate the Month and Day into the forecast?

linest_m({<Day=>} total aggr(if(sum({<Day=>}PTPAmount),sum({<Day=>}PTPAmount)),Day),Day)*Day

+linest_b({<Day=>} total aggr(if(sum({<Day=>}PTPAmount),sum({<Day=>}PTPAmount)),Day),Day)

2 Replies
Highlighted

What exactly you want to do?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor
Contributor

I am wanting to forecast the PTPAmount by day then rolled up into Month.