Count Status

Mon, 08 Apr 2013 07:32:13 GMT

ID	STATUS	DATE	COUNT
4225	INPROGRESS	10/1/2012
4225	INPROGRESS	9/1/2012
4225	INPROGRESS	8/1/2012
4225	OPEN	7/1/2012
4225	INPROGRESS	6/1/2012
4220	OPEN	5/1/2012
4225	NEW	4/1/2012
4225	NEW	4/1/2012

I have the following data the situation is that against one id there are multiple status and dates. what I need is to count the top status after the status is changed from open to inprogress in the given scenario I only need the the top three status which is Inprogress and its count is 3 .

topic Count Status in QlikView

Count Status