topic Calculate concurrent sessions in QlikView

Calculate concurrent sessions

poonam_kulwal — Sat, 16 Nov 2024 03:31:43 GMT

Hi All,

I have sample from QV server Sessions log.

Data is about document access history (from access point).

SessionStart, SessionEnd, Document,Server,CalType

I want to calculate concurrent sessions:

Maximum concurrency per server

Maximum concurrency per server per CAL

What are the documents contributing for max concurrency?

How many sessions each of those document had?

Which document was the biggest contributor?

Appreciate your inputs on this.

Regards,

Poonam

Re: Calculate concurrent sessions

NadiaB — Thu, 23 May 2019 20:37:32 GMT

Hi @poonam_kulwal

Are you familiar with the Governance Dashboard? It has a section to analyze sessions and has most of what you have listed.

How to configure the Governance Dashboard

Kind Regards,

Re: Calculate concurrent sessions

rwunderlich — Thu, 23 May 2019 20:57:03 GMT

Attached is the general script I use to process QV Server Logs into QVDs, including concurrent session calculation. I calculate concurrency to the second but then save only the max value per hour and CAL Type. Feel free to modify to fit your own needs.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Calculate concurrent sessions

poonam_kulwal — Mon, 27 May 2019 09:27:42 GMT

Thanks Rwunderlich!

Appreciate your help.

Re: Calculate concurrent sessions

poonam_kulwal — Mon, 27 May 2019 09:28:39 GMT

Thanks NadiaG for Link to Governance dashboard!