Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I am not really understand the requirement. Perhaps this? Else please provide expected result as well
Count({<Score={">=1<=2"}>} Score)