Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sicdude
Contributor III
Contributor III

Count of Subset of data

I have a set of claims that all contain member information.  I want to get a count of Male/Female of the distinct member#'s.   I thought initially a simple count of gender field would be sufficient, but then I realized that I was counting the claims and not the distinct members.   

do I need to create the distinct member subset on load or is there a way to do it through an expression? I'm hoping there's a way to do it with an expression.   

11 Replies
Vegar
MVP
MVP

@MSchatz : like this maybe?

 

Count(Distinct {$< Gender={"Male"},EMPRESA = {"5"}>}member)

MSchatz
Contributor II
Contributor II

Perfeito!