topic Re: How to calculate differencing in time series data in Qlik Sense Data Load in App Development

How to calculate differencing in time series data in Qlik Sense Data Load

PoojaPrasad — Sat, 16 Nov 2024 04:33:11 GMT

Hello Experts,

I have a dataset with date and revenue. When I used time series arima model available in advanced analytics toolbox extension(R is integrated with Qlik Sense), I see seasonality in the chart.

I am trying to create a new column, revenue_diff to perform differencing by subtracting the previous day revenue from today's revenue:revenue_diff(t) = revenue(t) - revenue(t-1)

Any idea on how to do this in the data load editor? Any suggestion on analysis of time series data with seasonality and trends in qlik sense will be helpful.

Thank you,

Re: How to calculate differencing in time series data in Qlik Sense Data Load

dplr-rn — Thu, 26 Sep 2019 17:37:51 GMT

for new column use previous function.
so something like
load
*,
revenue- previous(revenue) as increase
...
order by date

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunctions/Previous.htm

Re: How to calculate differencing in time series data in Qlik Sense Data Load

PoojaPrasad — Fri, 27 Sep 2019 14:30:40 GMT

Thank you Dilipranjith. This is exactly what I was looking for.