Question about a loop on a specific column

benji1484 — Sat, 01 Oct 2022 03:28:57 GMT

Hi,

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.

Benjamin

Re: Question about a loop on a specific column

benji1484 — Mon, 03 Oct 2022 05:50:05 GMT

Any idea ?

topic Question about a loop on a specific column in App Development

Question about a loop on a specific column

Re: Question about a loop on a specific column