topic Re: divide one expression into other error for percentage in QlikView

divide one expression into other error for percentage

sweens78 — Wed, 14 Nov 2018 15:23:11 GMT

Hi Folks,m trying to divide one expression into another but Im getting an error Any ideas? Could be bracket

=num((Count({<CNSBridgingFollowup_ID={'1'}>} NEWKEYID)-Count({<CNSBridgingFollowup_ID={'1'}>} PatientsNotAssessed_ID))+Count({<CNSBridgingFollowup_ID={'2'}>} NEWKEYID)-Count({<CNSBridgingFollowup_ID={'2'}>} PatientsNotAssessed_ID))
/
((Count(NEWKEYID)-Count(PatientsNotAssessed_ID)-(Count({<NextReferralCareAppt_ID={'7'}>} NEWKEYID)-Count({<NextReferralCareAppt_ID={'7'}>} PatientsNotAssessed_ID)),'##.#%'))

Re: divide one expression into other error for percentage

sunny_talwar — Wed, 14 Nov 2018 15:43:07 GMT

Try this

=Num(
(Count({<CNSBridgingFollowup_ID = {'1'}>} NEWKEYID) -Count({<CNSBridgingFollowup_ID={'1'}>} PatientsNotAssessed_ID) + Count({<CNSBridgingFollowup_ID = {'2'}>} NEWKEYID) - Count({<CNSBridgingFollowup_ID = {'2'}>} PatientsNotAssessed_ID))
/
(Count(NEWKEYID) - Count(PatientsNotAssessed_ID) -Count({<NextReferralCareAppt_ID = {'7'}>} NEWKEYID) + Count({<NextReferralCareAppt_ID = {'7'}>} PatientsNotAssessed_ID))
,'##.#%')

Re: divide one expression into other error for percentage

nandakishorek — Wed, 14 Nov 2018 15:44:06 GMT

=num(

((Count({<CNSBridgingFollowup_ID={'1'}>} NEWKEYID)
-
Count({<CNSBridgingFollowup_ID={'1'}>} PatientsNotAssessed_ID))
+
(Count({<CNSBridgingFollowup_ID={'2'}>} NEWKEYID)
-
Count({<CNSBridgingFollowup_ID={'2'}>} PatientsNotAssessed_ID)))

/

(Count(NEWKEYID)-Count(PatientsNotAssessed_ID)-Count({<NextReferralCareAppt_ID={'7'}>} NEWKEYID) - Count({<NextReferralCareAppt_ID={'7'}>} PatientsNotAssessed_ID))
,'#.##%')

FYI, Brackets are mis-placed