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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register 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