Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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]))