Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Nicolas89
Partner
Partner

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