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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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