Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
I think you are missing the curly brackets
Count({<[SVPPROFGENDER_entry] = {'Male'}>} Distinct [Client Id])
I think you are missing the curly brackets
Count({<[SVPPROFGENDER_entry] = {'Male'}>} Distinct [Client Id])
thank you, you are correct.
You can mark his reply correct so that others who stumble across this question will know there is an answer here.