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: 
Not applicable

QlikView Time Difference in Hours

Hi,

I have a pivot table like this as attached.

I want to add 3 expression to the Chart  like start, end and total.

Start = roadnetstart - dddriverstart (roadnetstart  is 9.30 am and dddriverstart  is 7.00 am. i  want Start as 2.30 hr)

End = roadnetend - dddriverend

Total = Start + End

i have made roadnet strt as right(Timestamp(ACTUAL_START-7/24),10)

DriverStrat as DDDriverStart

Is making three expression by using this is possible. Please let me know.

10 Replies
Not applicable
Author

Thanks Swuhl, it worked