Total number of users and active users

[Sivanesan]

Hi Everyone

One of our customer is looking for a report which shows the total number of users and the number of active users on a monthly basis in Qliksense. I have looked through the monitoring apps but couldn't find any such reports. Is it possible to generate such report? Any insights would be helpful

Regards

Sivanesan

Qlik Sense Enterprise on Windows 

[Sivanesan]

Hi @Clint194Lee 

Thanks for the immediate response. I can't find the AppSessionEvents in the QSR database

[Vegar · Accepted solution]

You might need to define what you mean by active user and user. If an active user is an user with an active session within the month, and an user is an user who have been active at least once then you could try to use the "Session monitor" application. 

To get the total user count create a KPI object

• Measures: Users

To get the active users per month, create a bar chart 

• Dimension: Month
• Measures: Users

See screenshot below as an example where I've used an Session monitor app to create such an dashboard

If you have a different definition of user and active user then you might have to end up looping through the log files found in ArchivedLogs. They contain a lot of historical detailed information.