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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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