Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
vpanchuda
Contributor III
Contributor III

Help in Set Expression

Hi Can any experts help me with below data.

I need the set expression to count the number of  A1,A2, and A3 and group it.

Condition

if Attendance is 'NO, and Grade is 'A1' and if date id blank count 1 

if Attendance is 'NO, and Grade is 'A2' and if date id blank count 1 

if Attendance is 'NO, and Grade is 'A3' and if date id blank count 1 

GradeAttendanceDate
A1NO01-02-2019
A2NO___
A3NO02-02-2019
A1NO___
A2NO04-02-2019
A3NO05-02-2019
1 Reply
sunny_talwar
MVP
MVP