Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this:
Count(TOTAL <SystemID> {<Date={">=$(=Date(vFdate))<=$(=Date(vEdate))"}>} AgentName)
Or just:
Count(TOTAL <SystemID> SystemID)
Thank you Vineeth
Really appreciate your efforts!.