Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Correct Expression

I try to calculate the total patient in  branch 'A' where Initial examination = 1

i try:

if(BranchID={'A'}) and ([has initial examination] = {'1'}), count(PaientID))

but it doesn't working.

13 Replies
roger_stone
Creator III
Creator III

Have you spelt PatientID correctly?

vikasmahajan

=Count( {<  BranchID={'A'} ,[has initial examination] = {'1'} >}  PaientID)

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

Maybe you can try this,

if((BranchID='A') and ([has initial examination] = 1), count(PaientID))


Chanty4u
MVP
MVP

u hve one extra brace....")"

please remove dis

Anonymous
Not applicable
Author

You can try:

if(BranchID='A', count(Distinct {<[has initial examination] = {'1'}>} PaientID))


Also check the spelling of PaientID, are you sure it is not PatientID?

Not applicable
Author

try this with and with out single quoates for 1

count({< BranchID={'A'} ,[has initial examination] = '1'>}PaientID)

settu_periasamy
Master III
Master III

May be like this

     if(BranchID='A' and [has initial examination] = '1', count(PaientID))

tyagishaila
Specialist
Specialist

I hope, below expression must work.

=Count({< BranchID ={'A'}, [has initial examination] = {1} >} PatientID)

Chanty4u
MVP
MVP

hi,

=Count({< BranchID ={'A'}, [has initial examination] = {'1'} >} PatientID)