Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
PoojaPrasad
Creator II
Creator II

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

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,

Labels (1)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

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

View solution in original post

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

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
Creator II
Creator II
Author

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