Qlik Community

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

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)
nicu1996
New Contributor III

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

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