Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
martinqlik
Contributor III
Contributor III
‎2017-04-18 06:15 PM

Calculating interval between different topics

Hello all,

I need to calculate the interval between different actions, for example.

Production1 starts at 8:00 pm

Production2 starts at 8:12 pm

Revision1 starts at 8:14 pm

etc...

The graphic must show total time and the interval between different steps as production1, production2, revision1 etc.

Does anybody know how to make this up?

Attaching a qvw with informations.

Thank you!

interval_test (1).qvw
358 Views
0 Likes
1 Solution

Accepted Solutions
Anil_Babu_Samineni
MVP
MVP
‎2017-04-18 10:12 PM

Try this

=Concat(Interval(End-Start, 'hh:mm:ss'),chr(10))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

308 Views
0 Likes
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2017-04-18 10:12 PM

Try this

=Concat(Interval(End-Start, 'hh:mm:ss'),chr(10))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
309 Views
0 Likes