RunningCount

[#1]

Hi All,

Greeting for the day!.

I am new to qlik and trying to build a basic running count table, I had already implemented this into SQL and now wanted to build this in qlik.

Basically, I have 3 major fields, SystemID, AgenName, Date. based on Date I want to run running count.

For more details, attaching the same set of data with required output.

[vinieme12]

[sunny_talwar]

May be this:

Count(TOTAL <SystemID> {<Date={">=$(=Date(vFdate))<=$(=Date(vEdate))"}>} AgentName)

[rubenmarin]

Or just:

Count(TOTAL <SystemID> SystemID)

[#5]

Thank you Vineeth

Really appreciate your efforts!.