Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
KRM2
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))

KRM2
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 ?