Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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