Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Cpedge99
Contributor
Contributor

Qlik consecutive result count

Apologies if this is very simple, new to Qlik.

I have a basic set of data like the below with a date field and a score
02/01/2019 3
02/01/2019 4
03/01/2019 2
03/01/2019 4
03/01/2019 3
03/01/2019 2
04/01 2019 5
04/01 2019 5

Looking to have a counter for our scoring system, on scores consecutively greater than 2 count up, once a score less than 1 is entered for the counter to thne reset to 0.

Does anyone have any ideas on how this could be done

1 Reply
Anil_Babu_Samineni

I am not really understand the requirement. Perhaps this? Else please provide expected result as well

Count({<Score={">=1<=2"}>} Score)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful