topic Re: Qlik Sense - Interval based on condition in App Development https://community.qlik.com/t5/App-Development/Qlik-Sense-Interval-based-on-condition/m-p/1441156#M34862 <HTML><HEAD></HEAD><BODY><P>can you share sample app?</P></BODY></HTML> Thu, 09 Nov 2017 06:14:20 GMT shraddha_g 2017-11-09T06:14:20Z Qlik Sense - Interval based on condition https://community.qlik.com/t5/App-Development/Qlik-Sense-Interval-based-on-condition/m-p/1441153#M34859 <HTML><HEAD></HEAD><BODY><P>Dear Expert, </P><P>How to get day difference based on condition?</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Interval between day 3 H1 to day 18 H1 is 15</SPAN></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182625_Capture.PNG" style="height: 466px; width: 620px;" /></P></BODY></HTML> Thu, 09 Nov 2017 03:19:30 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Interval-based-on-condition/m-p/1441153#M34859 sth_wch004 2017-11-09T03:19:30Z Re: Qlik Sense - Interval based on condition https://community.qlik.com/t5/App-Development/Qlik-Sense-Interval-based-on-condition/m-p/1441154#M34860 <HTML><HEAD></HEAD><BODY><P>how do you get that?</P><P></P><P>can you elaborate ?</P></BODY></HTML> Thu, 09 Nov 2017 05:54:59 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Interval-based-on-condition/m-p/1441154#M34860 shraddha_g 2017-11-09T05:54:59Z Re: Qlik Sense - Interval based on condition https://community.qlik.com/t5/App-Development/Qlik-Sense-Interval-based-on-condition/m-p/1441155#M34861 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Hi Shraddha,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">[Date] - [Date]&nbsp; = Interval </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">18 -&nbsp; 3 = 15</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Thu, 09 Nov 2017 06:10:29 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Interval-based-on-condition/m-p/1441155#M34861 sth_wch004 2017-11-09T06:10:29Z Re: Qlik Sense - Interval based on condition https://community.qlik.com/t5/App-Development/Qlik-Sense-Interval-based-on-condition/m-p/1441156#M34862 <HTML><HEAD></HEAD><BODY><P>can you share sample app?</P></BODY></HTML> Thu, 09 Nov 2017 06:14:20 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Interval-based-on-condition/m-p/1441156#M34862 shraddha_g 2017-11-09T06:14:20Z Re: Qlik Sense - Interval based on condition https://community.qlik.com/t5/App-Development/Qlik-Sense-Interval-based-on-condition/m-p/1441157#M34863 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Thanks,<BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Sure, please refer attached.</SPAN></P></BODY></HTML> Thu, 09 Nov 2017 06:16:54 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Interval-based-on-condition/m-p/1441157#M34863 sth_wch004 2017-11-09T06:16:54Z Re: Qlik Sense - Interval based on condition https://community.qlik.com/t5/App-Development/Qlik-Sense-Interval-based-on-condition/m-p/1441158#M34864 <HTML><HEAD></HEAD><BODY><P>Thanks for the help,</P><P></P><P>i managed to get the result by using Previous - script function.</P><P></P><P></P><P>LOAD</P><P>*,</P><P> IF([Location] = PREVIOUS([Location]),[Date] - PREVIOUS([Date])) AS Interval</P><P>RESIDENT [Sheet2]</P><P>ORDER BY [Location]</P><P>;</P><P>DROP TABLE [Sheet2];</P></BODY></HTML> Thu, 09 Nov 2017 07:20:12 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Interval-based-on-condition/m-p/1441158#M34864 sth_wch004 2017-11-09T07:20:12Z