Grouping and Counting

[learnerqlik53]

Hi All,

I am trying to Calculate :

Count(Name) where Sum(Meeting)={0}/Count(Name) grouping by Name

DB: Attached Excel data below

Script:

LOAD Name,
Only(Meeting) as Meeting,
Only(Age) as Age,
Only(JobLevel) as JobLevel,
Only(Salary) as Salary,
sum(Meeting) as Meeting1,
(month(Date)) as Month,
(year(Date)) as Year
FROM
/location of file/
group by Name,month(Date),year(Date)

Issue which I am facing is i want to do bifurcation with Month and Year. If i remove Month and Year from grouping then I am getting Sum(Meeting) properly else i am getting duplicates like:

Name , Month, Meeting1

Heena, Jan,0

Heena,Feb,1

How to get KPI where i can get "Count(Name) where Sum(Meeting1)=0 "

[Steven_Haught]

I am sure I am missing something in your request, but you could use set analysis to do your KPI request at the end:

count({<Meeting1={0}>}Name)

Please let me know if this is not what you were looking to achieve.