Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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]))