Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
poonam_kulwal
Partner
Partner

Count of active document

Hi All,

I have data for QV server session log.

Data is about when the document opened and closed on access point.

I want to count concurrent sessions for document on Daily/Hourly basis.

Sample data in first pic.

Sample_Data.png

In above data, row number 6, document was active for hour 10 and hour 11.

Row number 15, document was active for hour 14, hour 15 and hour 16.

I want hourly count when document was active.

Basically result as sown below

Concurrent.png

This is sample data. I have data for multiple servers, multiple documents and I have 3 years data.

Appreciate your help on this.

Thanks & Regards,

Poonam

1 Reply
JordyWegman
Partner
Partner

Hi,

First get with DoDir and a For each loop all the session logs.

Then create a timetable for all hours/minutes/seconds.

Map all the session logs to this table.

Load the table and do a count on the hours.

Jordy

Climber

Work smarter, not harder