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.
See Attached updated version
Hi,
Do you wish to do this in the script or the front end?
A few threads:
https://community.qlikview.com/thread/65358
I wanted to do this on front end as the calculation should change based on dates filtered.
Those threads will definitely give you the right idea then.
It is all about RANGESUM(ABOVE
Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.
Sorry, but not able to understand the functionality of running count or running sum.
Can you please help me. attaching the qvw.
Hi Vikas, if it's in a straight table you can check the 'full accumulation' option in the expressions tab.
can you please help me to understand the functionality of accumulation. this is new to me
If you only want to add an autonumeric, you just need to add an expression with "RowNo(TOTAL)"
Sorry, I think this was caused by my bad english, I misunderstood the requirements.
No, let say i select Start date - 4 October and End date - 15 October, the result should be like below
SystemID | AgentName | running count | count |
A | A1 | 1 | 4 |
A | A2 | 2 | 4 |
A | A3 | 3 | 4 |
A | A4 | 4 | 4 |
B | B1 | 1 | 4 |
B | B2 | 2 | 4 |
B | B3 | 3 | 4 |
B | B4 | 4 | 4 |
C | C1 | 1 | 1 |