Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
YoussefBelloum
Champion
Champion

Count based on date range

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:

count.png

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 

 

Labels (3)
0 Replies