help (set an expression with more than one condition)

[#1]

hi.. i'm new to qv..

I want to make a gauge chart and expression that I want to use in chart is

SELECT COUNT  from STUDENT where GRADE='SENIOR' and IPK='<3'

+

SELECT COUNT  from STUDENT where GRADE='SOPHOMORE' and IPK='<3'

how can I do this, can somebody help me to create an expression??

[Nicole-Smith · Accepted solution]

count({<Grade={'SENIOR'},IPK={'<3'}>}YourStudentField)+count({<Grade={'SOPHOMORE'},IPK={'<3'}>}YourStudentField)

Replace YourStudentField with a student ID field or name field or whatever you have that identifies a student.

[kiranmanoharrode]

try this.........

=count({<Grade={"SENIOR","SOPHOMORE"},IPK={"<3"}>}StudentField)

Regards,

Kiran Rode

+91 8976977897

[#4]

Just a small variation to what Nicole mentioned.

=count({<Grade={'SENIOR','SOPHOMORE'}, IPK={'<3'}>}Students)

Thanks

AJ

[#5]

Thanks Nicole 
very help