Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
martinqlik
Contributor III
Contributor III

Calculating interval between different actions

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!

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Don't create double post for single issue

Calculating interval between different topics

And, Answer for your question is Text object don't have capable for multiple values at a time. You can create straight / pivot table for the same. It should work. Still you want in text object then try like this

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

Capture.PNG

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

1 Reply
Anil_Babu_Samineni

Don't create double post for single issue

Calculating interval between different topics

And, Answer for your question is Text object don't have capable for multiple values at a time. You can create straight / pivot table for the same. It should work. Still you want in text object then try like this

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

Capture.PNG

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