topic Re: Need help in Set Analysis in QlikView

Need help in Set Analysis

Wed, 13 Nov 2013 10:47:41 GMT

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

Re: Need help in Set Analysis

narband2778 — Wed, 13 Nov 2013 10:52:51 GMT

Hi,

try this

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

regards,

Naresh

Re: Need help in Set Analysis

rajni_batra — Wed, 13 Nov 2013 10:56:57 GMT

Try

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

Regards,

Rajni

Re: Need help in Set Analysis

israrkhan — Wed, 13 Nov 2013 11:07:54 GMT

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))

Re: Re: Need help in Set Analysis

rustyfishbones — Wed, 13 Nov 2013 11:11:56 GMT

try

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

see attached qvw

Re: Need help in Set Analysis

Thu, 14 Nov 2013 07:26:29 GMT

Hi,

try this

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