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: 
JoseGarcia
Creator III
Creator III

Date calculations

Hi there, 

need to substract date & time dimension to give me total time taken.
Dimension data is displayed: 

JoseGarcia_0-1633529281481.png

formula is:
axle1finish - axle1start

Using date & time function, but unable to get data in a way that allows me to perform any calculation.
Could anyone assist?
Thanks

Labels (1)
10 Replies
JoseGarcia
Creator III
Creator III
Author

@stevejoyce & @mato32188 

Thank you both! 

Time stamping & using interval function worked.

JoseGarcia_1-1633622000364.png


JoseGarcia_0-1633621941790.png