Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
CostinelRO
Contributor II
Contributor II

Delta between rows

Hello,

Starting from the bellow table(Delta is the desired output) I would like to get the delta between rows and from that data to make a graph.

Initially, every minute I had a value, but I used AGGR to get the hourly average( AGGR(AVG(values),ora).

What is the best way get the delta between the rows in order to display it in a graph ?

table.png

 

Thank you,

Costi

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

@CostinelRO  you an try below in expression. Make sure that your dimension is sorted by hour otherwise above function won't work as expected

=value-above(Value)

View solution in original post

2 Replies
Kushal_Chawda

@CostinelRO  you an try below in expression. Make sure that your dimension is sorted by hour otherwise above function won't work as expected

=value-above(Value)

View solution in original post

CostinelRO
Contributor II
Contributor II
Author

Thank you @Kushal_Chawda .