Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 (2)
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.