consecutive leave days

[caswellmotati]

Please help, I trying to check employees  who took their leave in consecutive days.

I have used this expression but its not working.

sum(if(START_DATE - Before([LEAVE START DATE])<=1,[Consecutive Days]))

I checking the difference from previous row with the current.

[jcampbell474]

Please see the thread here: https://community.qlik.com/thread/110326

Some code in the load script counts sequential worked days.  Then, your expression can be something like: If(max(seqdays) > 1, 'Yes','No').  Provided you have Employee as a dimension.

HTH,

Jason