Forecast in Qlikview

Fri, 06 Jan 2012 10:42:48 GMT

Hello,

I got a chart with the evolution of efficiency rate and I am trying to display forecast for the next month.

For the moment I am just using the trend of my line and displaying it in the future. I got this expression :

If( $(EfficiencyRate),

$(EfficiencyRate),

If( date >= Date(Now()),

linest_m(TOTAL aggr(if($(EfficiencyRate),$(EfficiencyRate)),date),date)*date

linest_b(TOTAL aggr(if($(EfficiencyRate),$(EfficiencyRate)),date),date)

)

I got dates of the next month with no value for the efficiency rate.

But if I select a value in one of my lists, the forecast is not displayed. Only dates with value are displayed (past values). Future dates are not available.

Forecast is not displayed if I delete the TOTAL key word in my expressin...

Is there a solution for having my forecast in all cases ?

Forecast in Qlikview

cesaraccardi — Fri, 06 Jan 2012 15:45:49 GMT

Hello,

Just a tip, never use functions like Now() in your charts because this kind of function is evaluated all the time decreasing performance. You could store its value once in a variable and use it in your expression.

Regards,

Cesar.

topic Forecast in Qlikview in QlikView

Forecast in Qlikview

Forecast in Qlikview