I am trying to get a working time series forecast in Qlik Sense. At first I tried the Advanced Analytics Toolbox, but the time series components of that extension are broken and do not work as intended. I was able to do the analysis that I wanted in R Studio as a proof of concept, and now I want to reproduce the results in Qlik Sense. The goal is to get ARIMA forecast predictions for each future month.
I have been able to get simple R scripts to work such as:
R.ScriptEval('variable = q$test; variable',
Sum([REVENUE]) as test
and the data is properly sliced by the dimension in the line graph.
I have written the following analysis in R which correctly creates and ARIMA model and forecasts future periods:
arima = read.csv("diagm.csv")
vals = arima$rev
vals = as.numeric(vals)
tsobj = ts(vals, start = c (2014, 10), end = c(2018, 5), frequency = 12)
Hello Elliot, I have been trying the same with unfortunately very dismal results. Could you tell me what error the R server is showing when you're applying this script? Also, please share the dataset if you can.