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: 
Anonymous
Not applicable

Forecasting

Hi All

I wanted to forecast based on payments

eg:

For next 5 years

We use:

Weekly

Monthly

fortnight

So i want a calendar to say

show me next 5 years

If weekly = today + weeks

If Monthly =today + Month

If Fortnight = today + 2 weeks

to forecast how long if customer A pays £10 per month and owes £1000

Is there a way to do this?

2 Replies
avinashelite

if you want to create the Calendar data for next 5 years then we can easily achieve this in the Qlikview but if you want the forecasting for next 5 years then that might not be possible ....for that you need to prepare that in script or in another predictive modeling tools like R etc and then you need feed the data to Qlikview this is the way.

Or

try with the forcasting option in the presentation tab with the full accumation option in the expression tab that might help you

HirisH_V7
Master
Master