topic getting an error in % in QlikView

getting an error in %

sweens78 — Tue, 20 Nov 2018 19:07:56 GMT

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)),'##.#%')

skamath1 — Tue, 20 Nov 2018 19:25:41 GMT

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 — Tue, 20 Nov 2018 19:28:12 GMT

Hi Skamath I need it to display in % do.

skamath1 — Tue, 20 Nov 2018 19:44:13 GMT

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