Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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)
3 Replies
Sayed_Mannan
Creator II
Creator II

have you tried above function instead of below?

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

KavyaM
Contributor II
Contributor II
Author

Yes,I tried using Above as well but in vain. I tried various expressions but not getting the desired result. 

 

Sayed_Mannan
Creator II
Creator II

can you share some sample of data that are coming inside load_date_est  field ?