I have a line chart with data.
I want to Predict the next one month Sales based on the Current Sales.
Can we do it in Qlikview ??
I want the Predictive data to be displayed in Dotted Lines
Thanks & Regards,
from QlikView reference:
Backcast This function operates on trend lines. Enter into the text edit box how far back
you would like to estimate the trend line. The backcast portion of trend lines is displayed as dotted.
Forecast Enter into the text edit box how far you wish to predict the trend line. The forecast portion of trend lines is displayed as dotted.
You want like following:
Create a variable vWhatIf and use it in slider
For slider use following setting
in expression use
2nd expression for forecast:(sum(sales* (1 + vWhatIf))
As you told, you like to display predicted data on the chart. So, i thing trendline and forecast will not be good solution in your case. I think you should rather calculate your prediction in load script or in expressions, depending if your prediction algorithm depends less or more on user selections.