# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for
Did you mean:
Creator

## Expand Formula

The formula below counts total distinct number of clients within the data set. I'm not familiar with the structure of the formula. How would I add an addtional criteria like gender equal to male?

Gender column is [SVPPROFGENDER_entry]

=Count({

(\$<[Entry Date]={"<=\$(=EndDate)"},[Entry Exit Has No Exit Date]={'Yes'}>

+\$<[Entry Date]={"<=\$(=EndDate)"},[Exit Date]={">=\$(=StartDate)"}>

)}Distinct([Client Id]))

5 Replies
MVP

Something like this

=Count({(\$<[Entry Date] = {"<=\$(=EndDate)"}, [Entry Exit Has No Exit Date] = {'Yes'}>

+\$<[Entry Date] = {"<=\$(=EndDate)"}, [Exit Date] = {">=\$(=StartDate)"}>

)*\$<[SVPPROFGENDER_entry] = {'Male'}>}Distinct([Client Id]))

MVP

Or you can do this

=Count({(\$<[Entry Date] = {"<=\$(=EndDate)"}, [Entry Exit Has No Exit Date] = {'Yes'}, [SVPPROFGENDER_entry] = {'Male'}>

+\$<[Entry Date] = {"<=\$(=EndDate)"}, [Exit Date] = {">=\$(=StartDate)"}, [SVPPROFGENDER_entry] = {'Male'}>

)}Distinct([Client Id]))

Creator
Author

Thank you Sunny. Our vendor updated their custom version of Qlik. What I thought I understood, changed.

MVP

Not sure I understand... are you saying that the issue has been resolved? If that's what it is, then great... else can you elaborate on what you mean?

Creator
Author

Your formula is correct. The issue is our vendor and Qlik. Our vendor switched over from using ART (Business Objects) to Qlik. Our vendor is working on setting up Qlik. They did an upgrade to Qlik and all the previous work you help me with is no applies.

Tags
Community Browser