topic Calculating interval between different topics in QlikView https://community.qlik.com/t5/QlikView/Calculating-interval-between-different-topics/m-p/1339098#M842660 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hello all,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I need to calculate the interval between different actions, for example.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Production1 starts at 8:00 pm</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Production2 starts at 8:12 pm</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Revision1 starts at 8:14 pm</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">etc...</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">The graphic must show total time and the interval between different steps as production1, production2, revision1 etc.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">Does anybody know how to make this up?</SPAN></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Attaching a qvw with informations.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thank you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT martinqlik 2020-11-25T16:16:04Z Calculating interval between different topics https://community.qlik.com/t5/QlikView/Calculating-interval-between-different-topics/m-p/1339098#M842660 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hello all,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I need to calculate the interval between different actions, for example.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Production1 starts at 8:00 pm</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Production2 starts at 8:12 pm</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Revision1 starts at 8:14 pm</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">etc...</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">The graphic must show total time and the interval between different steps as production1, production2, revision1 etc.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">Does anybody know how to make this up?</SPAN></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Attaching a qvw with informations.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thank you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculating-interval-between-different-topics/m-p/1339098#M842660 martinqlik 2020-11-25T16:16:04Z Re: Calculating interval between different topics https://community.qlik.com/t5/QlikView/Calculating-interval-between-different-topics/m-p/1339099#M842663 <HTML><HEAD></HEAD><BODY><P>Try this</P><P><STRONG>=Concat(Interval(End-Start, 'hh:mm:ss'),chr(10))</STRONG></P></BODY></HTML> Wed, 19 Apr 2017 02:12:48 GMT https://community.qlik.com/t5/QlikView/Calculating-interval-between-different-topics/m-p/1339099#M842663 Anil_Babu_Samineni 2017-04-19T02:12:48Z