Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need to write an expression to find the count

Hi All,

I have 3 columns User Id, Name , Test Score with values ,but there are null values for Test score alone,

I need to write an expression to find the count of User Id's with Test Score to find out the percentage of Users who have completed the tests

Attached is the data sheet.

Tried with the below expression but it failed..

count(if not isnull(testscore), testscore))


1 Reply
tresesco
MVP
MVP

try like:

=count(if (len(trim([Test Score]))>0, [Test Score]))