Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count Status

IDSTATUSDATECOUNT
4225    INPROGRESS10/1/2012
4225    INPROGRESS9/1/2012
4225    INPROGRESS8/1/2012
4225    OPEN7/1/2012
4225    INPROGRESS6/1/2012
4220    OPEN5/1/2012
4225    NEW4/1/2012
4225    NEW4/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 .

0 Replies