Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

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
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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!

Labels (1)
Labels
interval_test (1).qvw
870 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

820 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
821 Views
0 Likes