Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
allsolution
Contributor II

How to make time interval from date time?

Hello mates, I would like display as time interval from date. How can I make it?

I have datatime table like this:

allsolution_0-1743478058476.png

I would like create line chart desired picture:

allsolution_1-1743478417449.png

 

Labels (4)
1 Solution

Accepted Solutions
PrashantSangle

use hour() to take hour from date & timestamp.

 

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

2 Replies
PrashantSangle

use hour() to take hour from date & timestamp.

 

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
allsolution
Contributor II
Author

It was easier than I thought. Thank you mate