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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
sweens78
Creator
Creator

getting an error in %

Guys I have below expression but keeping getting an error, is it bracket?

 

=((Count(NEWKEYID)-Count(PatientsNotAssessed_ID))/count(Hospital))
/
(
Max(Aggr(Count(NEWKEYID)-Count(PatientsNotAssessed_ID), Hospital)),'##.#%')

3 Replies
skamath1
Creator III
Creator III

Try the following

 

=((Count(NEWKEYID)-Count(PatientsNotAssessed_ID))/count(Hospital))
/
(Max(Aggr(Count(NEWKEYID)-Count(PatientsNotAssessed_ID), Hospital)))

 

Apply number formating under the measure 

sweens78
Creator
Creator
Author

Hi Skamath I need it to display in % do.

skamath1
Creator III
Creator III

 


Capture.PNG

You can apply the format in the measure under the Number Formatting as shown above