Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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!”