Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
saik
Contributor II
Contributor II

Help Needed

 

Hi Team,

I have column  name  'Breached' having  values   'yes' or 'No' . I need to count only breached =yes  as per the  Assignment Group wise.

Could you help me on this. 

 

Note : Novice user to Qlik Sense.

 

Thanks,

Sai.

 

1 Reply
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try:

sum(aggr(count(if(Breached='yes',1)),[Assignment Group]))