Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression

=if([BranchID]= '1',count(PatientID),count(PatientID where Branch ID = '1')

or

=Count (PatientID) where BranchID = '1'

How can I write this expression with a correct way ?!

Regards

1 Solution

Accepted Solutions
robert_mika
Master III
Master III

count({<[BranchID]={ '1'}>}PatientID)

Feeling Qlikngry?

How To /Missing Manual(25 articles)

View solution in original post

3 Replies
robert_mika
Master III
Master III

count({<[BranchID]={ '1'}>}PatientID)

Feeling Qlikngry?

How To /Missing Manual(25 articles)

Kushal_Chawda

=count(if(BranchID='1',BranchID))

HirisH_V7
Master
Master

Hi ,

=Aggr(If(BranchID=1,Count(Patient)),BranchID)

PFA,

Hope this Helps,

Regards,

Hirish

HirisH
“Aspire to Inspire before we Expire!”