topic Calculating interval between different actions in QlikView https://community.qlik.com/t5/QlikView/Calculating-interval-between-different-actions/m-p/1339051#M412700 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P>I need to calculate the interval between different actions, for example.</P><P></P><P>Production1 starts at 8:00 pm</P><P>Production2 starts at 8:12 pm</P><P>Revision1 starts at 8:14 pm</P><P>etc...</P><P></P><P>The graphic must show total time and the interval between different steps as production1, production2, revision1 etc.</P><P></P><P><SPAN style="font-size: 10pt;">Does anybody know how to make this up?</SPAN></P><P></P><P>Attaching a qvw with informations.</P><P></P><P>Thank you!</P></BODY></HTML> Tue, 18 Apr 2017 22:13:51 GMT martinqlik 2017-04-18T22:13:51Z Calculating interval between different actions https://community.qlik.com/t5/QlikView/Calculating-interval-between-different-actions/m-p/1339051#M412700 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P>I need to calculate the interval between different actions, for example.</P><P></P><P>Production1 starts at 8:00 pm</P><P>Production2 starts at 8:12 pm</P><P>Revision1 starts at 8:14 pm</P><P>etc...</P><P></P><P>The graphic must show total time and the interval between different steps as production1, production2, revision1 etc.</P><P></P><P><SPAN style="font-size: 10pt;">Does anybody know how to make this up?</SPAN></P><P></P><P>Attaching a qvw with informations.</P><P></P><P>Thank you!</P></BODY></HTML> Tue, 18 Apr 2017 22:13:51 GMT https://community.qlik.com/t5/QlikView/Calculating-interval-between-different-actions/m-p/1339051#M412700 martinqlik 2017-04-18T22:13:51Z Re: Calculating interval between different actions https://community.qlik.com/t5/QlikView/Calculating-interval-between-different-actions/m-p/1339052#M412701 <HTML><HEAD></HEAD><BODY><P>Don't create double post for single issue</P><P><A href="https://community.qlik.com/message/1252639">Calculating interval between different topics</A></P><P></P><P>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</P><P><STRONG>=Concat(Interval(End-Start, 'hh:mm:ss'),chr(10))</STRONG></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/160453_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 19 Apr 2017 02:12:32 GMT https://community.qlik.com/t5/QlikView/Calculating-interval-between-different-actions/m-p/1339052#M412701 Anil_Babu_Samineni 2017-04-19T02:12:32Z