First excuse my English, it's not my native langage. I will try to be clear in my question and if it's not the case, don't hesitate to ask for more precisions.
I'm working on a ERP output and there are some rows to group, based on the dates. You can download a simplified version attached.
My goal is to know every consecutive days of absence for each worker. The ERP creates a new row every 15 days of absence, and I have to look at the start and end dates as rules to group to do the grouping.
To do so, in Excel I use a column "index" initialized in the first case "F2" at 0.
Then I try to see if the previous row has the same matricule and if the "start date" is equals to the precedent line "end date" + 1 day.
--> F3 =IF (AND (A3=A2; C3= D2+1); F2 ; F2 + 1)
with A : matricule, C : start date, D : end date and F my calculated index column.
After it, I can do a simple group by loading in qliksense to count the relative number of days.
But is it possible to calculate the index column with these rules directly in Qliksense ? I've try several ways without succeding.
Thank you in advance for your help and I remain at your disposal if necessary.
