topic How to Usage statistics of Qlikview Reports in QlikView

How to Usage statistics of Qlikview Reports

Tue, 18 Aug 2009 13:47:38 GMT

My customer wants to know once we have deployed Qlikview reports, how those reports are getting used. Some statistic related questions that are requested are

- How many times reports have been used in a time period

- Which are the top 10 used reports

- Which filters are the most used in a report

- Are there patterns of certain usage ( So as to provide design inputs for re-engineering reports). For ex, are they clicking on filter x, then drilling down to certain data and then clicking filter y.

Appreciate any inputs on how to obtain such metadata.

How to Usage statistics of Qlikview Reports

Tue, 18 Aug 2009 14:24:49 GMT

Hallo,

if you are useing publisher there are a lot of *.logs you can analyse.

See:

C:\Dokumente und Einstellungen\All Users\Anwendungsdaten\QlikTech\Publisher\CommandCenter\QVPR

Rainer

How to Usage statistics of Qlikview Reports

Tue, 18 Aug 2009 15:22:31 GMT

Thanks Rainer. I will look it up.

How to Usage statistics of Qlikview Reports

siz_mahleka — Thu, 15 Jul 2010 11:59:42 GMT

Hi,

How would one tackle this if you are not using publisher.

Kind Regards,

Siz.

How to Usage statistics of Qlikview Reports

siz_mahleka — Sat, 17 Jul 2010 22:07:46 GMT

Hi,

I found the session log file. It's default location is

C:\ProgramData\QlikTech\QVS

From the file you can get information about when a user logged in, how longe their session lasted and which document they accessed.

Kind Regards,

Siz.

Re: How to Usage statistics of Qlikview Reports

Tue, 31 Jan 2012 22:24:28 GMT

Here's my script to load in the Session files from C:\ProgramData\QlikTech\QlikViewServer\:

log_tmp:
LOAD [Exe Type], 
     [Exe Version], 
     [Server Started], 
     Timestamp, 
     Document, 
     [Document Timestamp], 
     [QlikView User], 
     [Exit Reason], 
     [Session Start], 
     [Session Duration], 
     [CPU spent (s)], 
     [Bytes Received], 
     [Bytes Sent], 
     Calls, 
     Selections, 
     [Authenticated user], 
     [Identifying user], 
     [Client machine identification], 
     [Serial number], 
     [Client Type], 
     [Client Build Version], 
     [Secure Protocol], 
     [Tunnel Protocol], 
     [Server Port], 
     [Client Address], 
     [Client Port], 
     [Cal Type], 
     [Cal Usage Count]
FROM
(txt, utf8, embedded labels, delimiter is '\t', msq);
log:
LOAD SubField([Document], '\', 5) as Document,
          [Session Start]
Resident log_tmp;
QUALIFY *;
log_raw:
LOAD *
Resident log_tmp;
UNQUALIFY *;
DROP Table log_tmp;

Re: How to Usage statistics of Qlikview Reports

Tue, 29 Jan 2013 13:31:03 GMT

Hi,

thank you so much.

It helped me to find statistical usage for my models!!

Inna.

Re: How to Usage statistics of Qlikview Reports

Tue, 29 Jan 2013 13:56:08 GMT

Hi Siz,

maybe you can help me.

I went to C:\ProgramData\QlikTech\QlikViewServer , notepad named sessions_QVY-NEW.

I see there all I need - models, logins of users etc.

What I don't understand is what column represents slices.

Is this column selections?

Because it shows very high numbers per session- hundreds and thousands.

Thanks,

Inna