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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sweens78
Creator
Creator

divide one expression into other error for percentage

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

2 Replies
sunny_talwar

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

=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