Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Future forecasts based on current revenues

Hi guys,

Need to create a revenue forecast of service contracts (so called Renewals, Subscriptions, etc.) based on the revenue of these contracts that has been generated in the past already.

First: We simply want to know the amount of revenue we probably will generate in future, when renewing those contracts.

XDatumEND is the latest month, the contract needs to be renewaled.


All information is stored in a SOURCE Table.


BUT not all of these contracts are of the same  runtime.

Most of the time contracts are sold for a period of 12 months (see first three rows of Source Table). But some are of a different duration (see row 4 and 5).

How to achieve a forecast based on an estimated future 12 MONTH (!!) renewal  as stated in the screenshot?

Any ideas are pretty appreciated as I'm getting crazy soon...

Many Thx

Joerg

0 Replies