Count based on date range

YoussefBelloum — Fri, 24 Sep 2021 10:30:46 GMT

Hello everyone,

hope you're doing well !

I have a FLAG column (with value =ok), I would like to count the number of 'ok' from each date (present in the table) and until an endDate (which is the Date+10 days, which is not calculated yet)

I'll try to explain with the dataset below:

so I need to count the number of FLAG where FLAG equal 'ok' on date range (FabricationDate), starting from the date which is on the line itself until FabricationDate<=FabricationDate + 10 days.

What is need to get is described on the red column (final expression).

Hope it is clear.

Thank you for your time.

Youssef

topic Count based on date range in QlikView

Count based on date range