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: 
JoannaManibo
Contributor II
Contributor II

Data count not reflecting correctly

I am using this formula "=Count({<[Gender]={'Male'}>}[Gender])" to get the total count per gender but the total count is not showing correctly. See the screen shot and correct total count per gender below:

Male: 4,439

Female : 4,583

Screenshot.PNG

10 Replies
niccolo_chiodar
Contributor II
Contributor II

You can try this, 

Count( {< Gender={'Male'} >} DISTINCT ID)

It's working for me.

 

Nik