# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
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
MVP

## 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
MVP

## 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 !!!
New Contributor II

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

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