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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Simple count of rows

I have the following data from the status logs:

Assume today is Dec 4th

IDDateStatus
A12/4/2012Docs Received
A12/3/2012Docs Sent
A12/2/2012Docs Requested
B12/2/2012Docs Sent
B11/1/2012Docs Requested
C12/4/2012Docs Requested
D12/3/2012Docs Requested

How can I get the counts as in below report?

StatusAs of YesterdayAdditionsSubstractionAs of Today
Docs Received0101
Docs Sent2011
Docs Requested2002

Thanks,

Dinesh.

0 Replies