Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jbakerstull
Contributor

Set Expression Queston

I'm new to Qlik and just playing around learning how to create set expressions.

In the expression below I'm trying to count total males. The edit expression shows the syntax being correct but the result is 0.

I can't figure out what I'm doing incorrectly. Any advice would be great. Thanks.

Count({<[SVPPROFGENDER_entry]='Male'>}Distinct[Client Id])

1 Solution

Accepted Solutions
MVP
MVP

Re: Set Expression Queston

I think you are missing the curly brackets

Count({<[SVPPROFGENDER_entry] = {'Male'}>} Distinct [Client Id])

3 Replies
MVP
MVP

Re: Set Expression Queston

I think you are missing the curly brackets

Count({<[SVPPROFGENDER_entry] = {'Male'}>} Distinct [Client Id])

jbakerstull
Contributor

Re: Set Expression Queston

thank you, you are correct.

drillnaut
Valued Contributor

Re: Set Expression Queston

You can mark his reply correct so that others who stumble across this question will know there is an answer here.