topic Interval with multi dimensions in App Development

topic Interval with multi dimensions in App Development https://community.qlik.com/t5/App-Development/Interval-with-multi-dimensions/m-p/1697658#M53392 <P>Hey! Sruggling to get the time in between 2 indicators, for a given date.<BR />See below example</P><TABLE width="358"><TBODY><TR><TD width="97"><FONT color="#000080">Exisiting Fields</FONT></TD><TD width="100"><FONT color="#000080">Exisiting Fields</FONT></TD><TD width="97"><FONT color="#FF0000">Desired Field</FONT></TD><TD width="64"> </TD></TR><TR><TD><FONT color="#000080">TimeStamp</FONT></TD><TD><FONT color="#000080">Status</FONT></TD><TD><FONT color="#FF0000">Status Duration</FONT></TD><TD> </TD></TR><TR><TD>01/02/20 2:43</TD><TD>ON</TD><TD>0.063877315</TD><TD> </TD></TR><TR><TD>01/02/20 4:15</TD><TD>OFF</TD><TD>0.018321759</TD><TD> </TD></TR><TR><TD>01/02/20 4:41</TD><TD>ON</TD><TD>0.035706019</TD><TD> </TD></TR><TR><TD>01/02/20 5:33</TD><TD>OFF</TD><TD>0.008414352</TD><TD> </TD></TR><TR><TD>01/02/20 5:45</TD><TD>ON</TD><TD>0.038310185</TD><TD> </TD></TR><TR><TD>01/02/20 6:40</TD><TD>OFF</TD><TD>0.000671296</TD><TD> </TD></TR><TR><TD>01/02/20 6:41</TD><TD>ON</TD><TD>0.043344907</TD><TD> </TD></TR><TR><TD>01/02/20 7:43</TD><TD>OFF</TD><TD>0.033784722</TD><TD> </TD></TR><TR><TD>01/02/20 8:32</TD><TD>ON</TD><TD>0.056840278</TD><TD> </TD></TR><TR><TD>01/02/20 9:54</TD><TD>OFF</TD><TD>null</TD><TD>end of day</TD></TR><TR><TD>01/03/20 0:58</TD><TD>ON</TD><TD>0.583333333</TD><TD> </TD></TR><TR><TD>01/03/20 14:58</TD><TD>OFF</TD><TD>null</TD><TD>end of day</TD></TR><TR><TD>01/04/20 1:51</TD><TD>ON</TD><TD>0.027650463</TD><TD> </TD></TR><TR><TD>01/04/20 2:31</TD><TD>OFF</TD><TD>0.033113426</TD><TD> </TD></TR><TR><TD>01/04/20 3:19</TD><TD>ON</TD><TD>0.02587963</TD><TD> </TD></TR><TR><TD>01/04/20 3:56</TD><TD>OFF</TD><TD>0.039872685</TD><TD> </TD></TR><TR><TD>01/04/20 4:53</TD><TD>ON</TD><TD>0.016909722</TD><TD> </TD></TR><TR><TD>01/04/20 5:18</TD><TD>OFF</TD><TD>0.022835648</TD><TD> </TD></TR><TR><TD>01/04/20 5:51</TD><TD>ON</TD><TD>0.052881944</TD><TD> </TD></TR><TR><TD>01/04/20 7:07</TD><TD>OFF</TD><TD>0.015856481</TD><TD> </TD></TR><TR><TD>01/04/20 7:30</TD><TD>ON</TD><TD>0.105810185</TD><TD> </TD></TR><TR><TD>01/04/20 10:02</TD><TD>OFF</TD><TD>null</TD><TD>end of day</TD></TR></TBODY></TABLE><P> </P><P>Any ideas how i could achieve that? Ultimately I will then sum the values on ON and OFF for each day. </P><P>Thanks very much!</P> Wed, 29 Apr 2020 11:22:59 GMT AlbL 2020-04-29T11:22:59Z Interval with multi dimensions https://community.qlik.com/t5/App-Development/Interval-with-multi-dimensions/m-p/1697658#M53392 <P>Hey! Sruggling to get the time in between 2 indicators, for a given date.<BR />See below example</P><TABLE width="358"><TBODY><TR><TD width="97"><FONT color="#000080">Exisiting Fields</FONT></TD><TD width="100"><FONT color="#000080">Exisiting Fields</FONT></TD><TD width="97"><FONT color="#FF0000">Desired Field</FONT></TD><TD width="64"> </TD></TR><TR><TD><FONT color="#000080">TimeStamp</FONT></TD><TD><FONT color="#000080">Status</FONT></TD><TD><FONT color="#FF0000">Status Duration</FONT></TD><TD> </TD></TR><TR><TD>01/02/20 2:43</TD><TD>ON</TD><TD>0.063877315</TD><TD> </TD></TR><TR><TD>01/02/20 4:15</TD><TD>OFF</TD><TD>0.018321759</TD><TD> </TD></TR><TR><TD>01/02/20 4:41</TD><TD>ON</TD><TD>0.035706019</TD><TD> </TD></TR><TR><TD>01/02/20 5:33</TD><TD>OFF</TD><TD>0.008414352</TD><TD> </TD></TR><TR><TD>01/02/20 5:45</TD><TD>ON</TD><TD>0.038310185</TD><TD> </TD></TR><TR><TD>01/02/20 6:40</TD><TD>OFF</TD><TD>0.000671296</TD><TD> </TD></TR><TR><TD>01/02/20 6:41</TD><TD>ON</TD><TD>0.043344907</TD><TD> </TD></TR><TR><TD>01/02/20 7:43</TD><TD>OFF</TD><TD>0.033784722</TD><TD> </TD></TR><TR><TD>01/02/20 8:32</TD><TD>ON</TD><TD>0.056840278</TD><TD> </TD></TR><TR><TD>01/02/20 9:54</TD><TD>OFF</TD><TD>null</TD><TD>end of day</TD></TR><TR><TD>01/03/20 0:58</TD><TD>ON</TD><TD>0.583333333</TD><TD> </TD></TR><TR><TD>01/03/20 14:58</TD><TD>OFF</TD><TD>null</TD><TD>end of day</TD></TR><TR><TD>01/04/20 1:51</TD><TD>ON</TD><TD>0.027650463</TD><TD> </TD></TR><TR><TD>01/04/20 2:31</TD><TD>OFF</TD><TD>0.033113426</TD><TD> </TD></TR><TR><TD>01/04/20 3:19</TD><TD>ON</TD><TD>0.02587963</TD><TD> </TD></TR><TR><TD>01/04/20 3:56</TD><TD>OFF</TD><TD>0.039872685</TD><TD> </TD></TR><TR><TD>01/04/20 4:53</TD><TD>ON</TD><TD>0.016909722</TD><TD> </TD></TR><TR><TD>01/04/20 5:18</TD><TD>OFF</TD><TD>0.022835648</TD><TD> </TD></TR><TR><TD>01/04/20 5:51</TD><TD>ON</TD><TD>0.052881944</TD><TD> </TD></TR><TR><TD>01/04/20 7:07</TD><TD>OFF</TD><TD>0.015856481</TD><TD> </TD></TR><TR><TD>01/04/20 7:30</TD><TD>ON</TD><TD>0.105810185</TD><TD> </TD></TR><TR><TD>01/04/20 10:02</TD><TD>OFF</TD><TD>null</TD><TD>end of day</TD></TR></TBODY></TABLE><P> </P><P>Any ideas how i could achieve that? Ultimately I will then sum the values on ON and OFF for each day. </P><P>Thanks very much!</P> Wed, 29 Apr 2020 11:22:59 GMT https://community.qlik.com/t5/App-Development/Interval-with-multi-dimensions/m-p/1697658#M53392 AlbL 2020-04-29T11:22:59Z