Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Nicolas89
Partner - Contributor II
Partner - Contributor II

Create a KPI based on _Qlik Sense Sessions monitor application

My application is based on the data of the _Qlik Sense Sessions monitor application. I would like to make a KPI that displays the number of incorrectly configured users, that is, users with empty boxes and those with "No" in the "Access to Stream?" Or "Access to App?" Or both.

Here are the codes of my measurements for the table:

"Access to Stream? »: = IF ((num (count ({<Session Count] = {1}>} DISTINCT [UserAttributes.userStreamRights]), '#, ## 0'))> 0, 'Yes', 'No')

"Access to App? "IF ((num (count ({<[Session Count] = {1}>} DISTINCT [UserAttributes.userAppAccess]), '#, ## 0'))> 0, 'Yes', 'No')

I put a lot of codes in different ways in the KPI using count. But nothing works. Could you help me ?

 

Capture Qlik com.JPG

0 Replies