Qlik Sense Set expression

[vpanchuda]

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 

Grade	Attendance	Date
A1	NO	01-02-2019
A2	NO	___
A3	NO	02-02-2019
A1	NO	___
A2	NO	04-02-2019
A3	NO	05-02-2019

[sunny_talwar]

So, based on this sample... you would want to see a count of 2?

[vpanchuda]

Hi Sunny

It should count only if there is a corresponding date.(i think my question is confusing)

Grade	Attendance	Date
A1	NO	01-02-2019
A2	NO	___
A3	NO	02-02-2019
A1	NO	___
A2	NO	04-02-2019
A3	NO	05-02-2019

My result table should be something line below.(it should not count if there is no date)

A1	1
A2	1
A3	2

[sunny_talwar]

This should work where Grade is a dimension

Count({<Attendance = {'No'}, Date = {"*"}>} Grade)

[vpanchuda]

Hi Sunny Used -={""} and worked , only problem is if I show it in a Pivot the null values Shows (-) , is there any way to make it 0 instead?

[sunny_talwar]

May be uncheck 'Suppress Zero-Values'

[vpanchuda]

I am not able to find this option in Pivot table in Qlik Sense

[sunny_talwar]

My bad, I was under the impression that you might be using QlikView... anyways I am not really sure what you have, would you be able to share a sample qvf to show the issue?