Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tred39
Contributor
Contributor

Need help reading this statement...

Need help reading this statement which was taken from the Text Object Properties  (General Tab) for a given object. What is displayed is a percentage number.

=num(count({$< DLP_Status={"Compliant"}>}DLP_User)/((count(DLP_User))-count({$< Authhost={"Server"}>}DLP_User)),'#,##0.00%')

  • DLP_Status has values "Compliant" and "Non-compliant"
  • DLP_User is the username
  • Authhost has values "Server" or <null>. Currently this number is 0 (zero).

 

Labels (5)
1 Reply
Vegar
MVP
MVP

Deciphering the expression:
=num(
count({$< DLP_Status={"Compliant"} >}DLP_User) // the number of DLP_User with DLP_Status=Compliant
/ //divided by
(
(count(DLP_User)) // no of DLP_User
-
count({$< Authhost={"Server"}>}DLP_User)) //no of DLP_User with Authhost= Server
,'#,##0.00%')

SUMMARY:
The expression:
[No of DLP_User with Compliant DLP_Status] / [No of all DLP_User except those with Server as Authhost]

Presented as a two decimal percentage with comma as thousand separator.