New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save \$400. Learn More
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)

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

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)