Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try this
Count({$<score={'0'}>}distinct(StudentId))
regards,
Naresh
Try
=Count({<Score-={''}>}StudentId)
Regards,
Rajni
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))
try
=Count({<Score-={'0',''}>}StudentId)
see attached qvw
Hi,
try this
=Count({<Score={'>=0'}>}StudentId)