Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
analystdude96
Contributor
Contributor

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

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. 

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

May be use this expression

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

View solution in original post

1 Reply
sunny_talwar

May be use this expression

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