# New to QlikView

Discussion board where members can get started with QlikView.

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
New Contributor III

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

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