topic Re: Forecasting in QlikView

Forecasting

Anonymous — Fri, 05 Feb 2016 11:42:48 GMT

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?

Re: Forecasting

avinashelite — Fri, 05 Feb 2016 12:05:00 GMT

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.

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

Re: Forecasting

HirisH_V7 — Fri, 05 Feb 2016 12:05:38 GMT

Hi,

Check this,

Forecasting in Qlikview

Prediction function in QlikView

What is the –What If Analysis in QlikView...

What If Analysis in Qlikview.docx

PFA,

HTH