Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
KavyaM
Contributor II
Contributor II

Calculation of time difference for consecutive date rows in Qliksense

How to get the time difference for consecutive rows in Qliksense expression?

I am trying to get the difference between 1st row-2nd row & 2nd row - 3rd row and so on in Qliksense using expression. load_date_est is the field used for Load time column. 

I tried using expression  ''Interval(load_date_est - Below(load_date_est)'' but not getting any result. 

KavyaM_0-1725022855042.png

Any help on this is much appreciated. 

Labels (3)
1 Reply
Sayed_Mannan
Creator II
Creator II

have you tried above function instead of below?

try this: Interval(load_date_est - Above(load_date_est))