Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
poonam_kulwal
Partner
Partner

Calculate concurrent sessions

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

 

 

 

Labels (1)
1 Solution

Accepted Solutions
rwunderlich

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

 

View solution in original post

4 Replies
NadiaB
Support
Support

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,

Note: if this suggestion helps to resolve the issue or answers your question, it will be appreciated if you select the "Accept as Solution" option.
We encourage you to visit our Knowledge Base https://qliksupport.force.com/QS_CoveoSearch when trying to find a solution related and not limited to: errors, feature requests, product defects. You can also visit our Qlik Help portal https://help.qlik.com/
rwunderlich

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

 

View solution in original post

poonam_kulwal
Partner
Partner
Author

Thanks Rwunderlich!

Appreciate your help.

poonam_kulwal
Partner
Partner
Author

Thanks NadiaG for Link to Governance dashboard!