Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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