Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Hi,
Check this,
Prediction function in QlikView
What is the –What If Analysis in QlikView...
What If Analysis in Qlikview.docx
PFA,
HTH