topic error in % expression in QlikView

error in % expression

sweens78 — Wed, 21 Nov 2018 13:03:11 GMT

Hi Folks

I seem to have problem with the % I have the below but its giving me a massive percentage any ideas, I think its my brackets again. I just want to add the two values together and then divide those into another number displaying the %

num((Count({<SelfHarmAct_ID={'10'}>} NEWKEYID)-Count({<SelfHarmAct_ID={'10'}>} PatientsNotAssessed_ID))

(Count({<SelfHarmAct_ID={'9'}>} NEWKEYID)-Count({<SelfHarmAct_ID={'9'}>} PatientsNotAssessed_ID))

/ (Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.##%')

Re: error in % expression

jfkinspari — Wed, 21 Nov 2018 14:48:54 GMT

You do seem to be missing a pair of brackets before you divide

num(

(

(Count({<SelfHarmAct_ID={'10'}>} NEWKEYID)-Count({<SelfHarmAct_ID={'10'}>} PatientsNotAssessed_ID))
+
(Count({<SelfHarmAct_ID={'9'}>} NEWKEYID)-Count({<SelfHarmAct_ID={'9'}>} PatientsNotAssessed_ID))
)
/ (Count(NEWKEYID)-Count(PatientsNotAssessed_ID))

,'##.##%')

Re: error in % expression

stigchel — Wed, 21 Nov 2018 13:14:57 GMT

I guess brackets and why not combine the two ID's, like

=num((Count({<SelfHarmAct_ID={'9','10'}>} NEWKEYID)-Count({<SelfHarmAct_ID={'9','10'}>} PatientsNotAssessed_ID))
/ (Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.##%')

Re: error in % expression

sweens78 — Wed, 21 Nov 2018 14:21:44 GMT

still seem to be be getting error jfkinspari

=(
num((Count({<SelfHarmAct_ID={'10'}>} NEWKEYID)-Count({<SelfHarmAct_ID={'10'}>} PatientsNotAssessed_ID))
+
(Count({<SelfHarmAct_ID={'9'}>} NEWKEYID)-Count({<SelfHarmAct_ID={'9'}>} PatientsNotAssessed_ID))
)
/ (Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.##%')