topic consecutive leave days in QlikView https://community.qlik.com/t5/QlikView/consecutive-leave-days/m-p/85108#M14002 <HTML><HEAD></HEAD><BODY><P>Please help, I trying to check employees&nbsp; who took their leave in consecutive days.</P><P>I have used this expression but its not working.</P><P><STRONG>sum(if(START_DATE - Before([LEAVE START DATE])&lt;=1,[Consecutive Days])) </STRONG></P><P><STRONG> </STRONG></P><P>I checking the difference from previous row with the current. </P></BODY></HTML> Thu, 24 May 2018 12:34:21 GMT caswellmotati 2018-05-24T12:34:21Z consecutive leave days https://community.qlik.com/t5/QlikView/consecutive-leave-days/m-p/85108#M14002 <HTML><HEAD></HEAD><BODY><P>Please help, I trying to check employees&nbsp; who took their leave in consecutive days.</P><P>I have used this expression but its not working.</P><P><STRONG>sum(if(START_DATE - Before([LEAVE START DATE])&lt;=1,[Consecutive Days])) </STRONG></P><P><STRONG> </STRONG></P><P>I checking the difference from previous row with the current. </P></BODY></HTML> Thu, 24 May 2018 12:34:21 GMT https://community.qlik.com/t5/QlikView/consecutive-leave-days/m-p/85108#M14002 caswellmotati 2018-05-24T12:34:21Z Re: consecutive leave days https://community.qlik.com/t5/QlikView/consecutive-leave-days/m-p/85109#M14003 <HTML><HEAD></HEAD><BODY><P>Please see the thread here: <A _jive_internal="true" href="https://community.qlik.com/thread/110326">https://community.qlik.com/thread/110326</A></P><P></P><P>Some code in the load script counts sequential worked days.&nbsp; Then, your expression can be something like: If(max(seqdays) &gt; 1, 'Yes','No').&nbsp; Provided you have Employee as a dimension.</P><P></P><P>HTH,</P><P>Jason</P></BODY></HTML> Thu, 24 May 2018 17:37:47 GMT https://community.qlik.com/t5/QlikView/consecutive-leave-days/m-p/85109#M14003 jcampbell474 2018-05-24T17:37:47Z