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

[PoojaPrasad]

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,

[dplr-rn · Accepted solution]

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/InterRecordFun...

[PoojaPrasad]

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