Combine 2 if into one expression

[Newbie_To_Qlik]

Hi All

I would need some help whereby the following 2 conditions need to be fulfill for me to count the number of [Schedule End date] occurrence

[Type]="OQ" and [Routine Schedule]='Yes',

Type	Routine Schedule	Schedule End Date
PM	Yes	09 Mar 2021
OQ	No	09 Mar 2021
Cal	Yes	09 Mar 2021
Cal	No	09 Mar 2021
PM	Yes	09 Mar 2021
OQ	Yes	09 Mar 2021
PM	Yes	09 Mar 2021
OQ	Yes	09 Mar 2021
PM	No	05 Mar 2021
PM	Yes	05 Mar 2021
PM	Yes	05 Mar 2021

Below is my expression and it doesn't work.

Count(if ([Type]='OQ', [Routine Schedule]='Yes',[Schedule End Date]))

Thanks 

[lironbaram · Accepted solution]

Hi 
This should work for you 

Count(if ([Type]='OQ' and [Routine Schedule]='Yes',[Schedule End Date]))