Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cdecluseau
New Contributor III

Qlik sense sheets usage

Hi,

I was wondering how we can know sheets usage by users of an application ?

I saw some topic in the Community without answer. I think that log form Proxy or Engine can contains this, but where ? I wan find this information and it's quite hard to read.

Operation monitor don't display this information and I don't see them in the data.

Should I put an higher log detail in the QMC ?

Thanks for your help and don't hesitate to ask me if necessary.

Tags (2)
12 Replies
cdecluseau
New Contributor III

Re: Qlik sense sheets usage

A little up... Can somebody help me ?

rittermd
Honored Contributor

Re: Qlik sense sheets usage

The apps sheet of the Operations Monitor has a table that does show the object or sheets along with the object id. The table is called App Object Details.

I have never tried it.  But there has to be a way to locate all of the sheets that make up an app in the repository and then possibly hit the same log file that they are getting the app activity from to get the sheet activity.

Just a guess.  If I have some time I will try to look into this.

cdecluseau
New Contributor III

Re: Qlik sense sheets usage

Hi ! Thanks for your answer. I imagine something like that but logs files are so difficult to read !

Re: Qlik sense sheets usage

Mark,

I am about to have a look into this.  Do you manage to have a look or know of any relevant documents / url's ?

Fortunately I have more exposure to hoiking data from log files than a sane person would dare admit to.

Re: Qlik sense sheets usage

Having poked around in the Ops Monitor it looks like it is using the Qlik Sense repository service API

Doing a REST call to https://localhost/qrs/app/object/full to get the App Object Name's.

It is now beer o'clock in the UK.  I'll see if I can poke further tomorrow.

e_petrasevicius
New Contributor II

Re: Qlik sense sheets usage

Hi Christophe,

I have tried to create an app to analyze user usage per sheet. First of all you need to set "Engine Traffic Logging" level from "Off" to "Info". It will give you all information about each user and movement though the app and selections user made. But take note : it will generate the huge amount of log files.

In these logs you will find field "Message". You need to extract "qGenericId" values from the message field. You will use these values to connect with information from QRS.

Next step to do connect to QRS via REST connector. You could use default connector "monitoring-app-object" to extract all app objects information. To create connection between Log files and QRS you need to use "qGeneric" values from Log files and "engineObjectId" from QRS.

Hope it will help you.

phaneendra_kunc
Valued Contributor III

Re: Qlik sense sheets usage

Any luck in creating the app? If so can you share the code here?

I agree enabling Traffic Logs are creating very big files. But want to see if you have a solution.

Thanks,

Phani

liam_hanninen
Contributor

Re: Qlik sense sheets usage

Any updates on this? This seems like a fundamental monitoring metric! I wish this was built out-of-the-box.

e_petrasevicius
New Contributor II

Re: Qlik sense sheets usage

Hi everyone, latest news on app status - postponed due to lack of time. Hope I will find time to finish until the summer. I will let you know if app status change.

Community Browser