Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to calculate Hours?

calculate hours between two dates like start date and end date. I have a qvw file attaching here can help on this. and i want to show that result in gantt chart

1 Reply
oknotsen
Master III
Master III

Hi,

([Start Time] - [Stop time]) * 24

or maybe better

round(([Start Time] - [Stop time]) * 24, 0.1)

Btw,

I noticed that one time field has Time with a capital letter and the other without. Consider being more consequent with your naming convention early in your development process as it will be hell to fix that later on.

May you live in interesting times!