Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!