How to Usage statistics of Qlikview Reports

[#1]

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.

[#2]

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

[#3]

Thanks Rainer. I will look it up.

[siz_mahleka]

Hi,

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

Kind Regards,

Siz.

[siz_mahleka]

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.

[#6]

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;

[#7]

Hi,

thank you so much.

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

Inna.

[#8]

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