Forecast from current date to year end

[Pomna]

Hello Experts,

I need help forecasting from current date to  year end. I have revenue, forecast revenue, expense and budgeted expense but am at a loss on how to calculate revenue and expense  from current date to year end. 

I have tried sum(forecast revenue) but the numbers do not add up. 

I would appreciate your help. Thanks

[Channa]

forecast is based on algorithem u using it dosent add up

use regression

[emrekaya]

Do you have your data based on dates? I mean, maybe you can use set analysis such as sum({<date='>today' , date='<max(date)'>} forecastrevenue)

This would be wrong but the idea may work.

[Pomna]

Thanks. Any suggestions on how to go about using regression in qlik sense?

[emrekaya]

It is difficult to make a comment without seeing your data but you can check date functions and set analysis from help.qlik.com