Count if record is not null in one column and contains '1' in another

[analystdude96]

Hello

I am trying to make a KPI that shows a count of the number of records where a date is present in the 'date' column, and a 1 is contained in a column called 'result'. 

For example:

Name     Result        Date 

Bob           1            02/02/2020

Jim            0              NULL

Sam          1              05/03/2020

Sandra     1             NULL

So here my KPI would show a count of two, as there are two records (Bob and Sam) that meet the criteria of a '1' in the  result column and are NOT null in the date column. 

Still pretty new to Qlik so I am sure there is an easy solution, the syntax is still a tad confusing at times! 

Many thanks. 

[sunny_talwar · Accepted solution]

May be use this expression

Count(DISTINCT {<Result = {'1'}, Date *= {"*"}>} Name)