Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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!