Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

j_schmidt
Contributor

User activity chart

Hi,

i would like to build a custom chart which displays the user activity on our charts.

I know there are pre-build monitoring charts in Qlik Sense but using them i frequently get performance issues with the Qlik server

and i also would like to only display a smaller customized part of them.

Right now, i would just like to display which users access which apps how often on which days.

Can somebody give me some tipps how to get this information from the internal Qlik data store (log files? database?).

Would be very glad for some advice.

Cheers,

John

7 Replies
beck110979
Valued Contributor III

Re: User activity chart

Hi John,

i have a question, which kind of database are you using? if you have within your database the field: last_activtity, you can implement this field in scrip-area in Qlik_Sense, but before you should create The Access Section-Concept, where you can restrict the access of any users to your app, and if you finished with Access_Section, you will be able to see on the base of field: last_activity,who of uses and how long have been used/ seen your app / dashboard.

to issue Access Section look at this: QlikView Tutorials | QlikView Security | Component Level Security in QlikView - YouTube

I hope that helps

Beck

ogster1974
Honored Contributor II

Re: User activity chart

why dont you

1. take a copy of the monitoring app.

2. Strip out all the sheets and visualisations you dont need. 

3. Identify only the fields that are used and modify the reload script to exclude all others so reducing time to reload and app size.

Then you'll have a monitoring app suited to your use case just take a copy of the orignal dont overwrite it.

I havent done this but thats probably where id start looking.

Regards

Andy

j_schmidt
Contributor

Re: User activity chart

Yes thats what i did at first.

The code in the data editor is quite hard to understand though if you dont have some basic knowledge of what information resides where :/

j_schmidt
Contributor

Re: User activity chart

Hi,

what do you mean which database?

I'm using Qkli Sense - can i select in which database Qkli Sense stores its user information?

beck110979
Valued Contributor III

Re: User activity chart

John,

with Database, i mean, wherefrom you take the data

j_schmidt
Contributor

Re: User activity chart

Yes thats what i thought

And thats exatcly my problem - i dont know where to take the data from :/

I just know Qlik stores it somewhere but i dont know where.

beck110979
Valued Contributor III

Re: User activity chart

Ah ok, that does look your sitation a bit another, you can use the Access Section, and in setting of QMC, you can generate a log-file, where you can see the information regarding your user-activity.

Or you should see all your fields in script-area within your qliksense ap. maybe you have this field: user_activity, last_acivity.

Beck

Community Browser