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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help in Set Analysis

Hi

Need your help in set analysis

I have data like this

Student    StudentId       Score

Mark              1                 92
Steve             2                 10
Tim                3
May               4      
Tom               5                 60
Kim                5                   0 

Now I need to get a count of Students who have scored,(zero to be included)

I tried using set analysis,but failed.

=count({$<score<>{}>}distinct(StudentId))

Need to use set analysis in particular,not sure how to use greater than or lesser than or not equal to operators in Set Analysis .

Any help is highly appreciated in this regard

Thanks in advance

5 Replies
narband2778
Creator II
Creator II

Hi,

try this

Count({$<score={'0'}>}distinct(StudentId))

regards,

Naresh

rajni_batra
Specialist
Specialist

Try

=Count({<Score-={''}>}StudentId)

Regards,

Rajni

israrkhan
Specialist II
Specialist II

Hi use below:

for all students who have 0 or more , only empty excluded.

Count({$<Score={'*'}- {''}>}distinct StudentId)

for those who have zero

Count({$<Score={'0'}>}distinct(StudentId))

for those who are null, empty

Count({$<Score={''}>}distinct(StudentId))

rustyfishbones
Master II
Master II

try

=Count({<Score-={'0',''}>}StudentId)


see attached qvw

Not applicable
Author

Hi,

try this

=Count({<Score={'>=0'}>}StudentId)