Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
aminehaddar
New Contributor II

How to calculate the number of students who have a note>0 ?

Hello,

I have:      studentID, note

How to calculate the number of students who have a note>0 ?

Greetings

1 Solution

Accepted Solutions

Re: How to calculate the number of students who have a note>0 ?

May be these?

If(Sum(note)>0, Count(studentID))

OR

If(note>0, Count(studentID))

OR

Count({<note = {'>0'}>} studentID)

OR

Count({<note = {"=Sum(note)>0"}>} studentID)

Life is so rich, and we need to respect to the life !!!
2 Replies

Re: How to calculate the number of students who have a note>0 ?

May be these?

If(Sum(note)>0, Count(studentID))

OR

If(note>0, Count(studentID))

OR

Count({<note = {'>0'}>} studentID)

OR

Count({<note = {"=Sum(note)>0"}>} studentID)

Life is so rich, and we need to respect to the life !!!
nicu1996
New Contributor II

Re: How to calculate the number of students who have a note>0 ?

=Count( {$<note={'>0'}>} studentID)

Community Browser