Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

can any one tell me how to count males based on Value 'Mr. in "ashok, Mr. saini' column name is employee name

I would appreciate if you can tell me how to count males based on Value 'Mr. in "ashok, Mr. saini' column name is employee name. I tried but it is returning only 0 value

Count({<[EMPLOYEE NAME]={MR.}>}[EMPLOYEE NAME])

1 Solution

Accepted Solutions
vvvvvvizard
Contributor III

Re: can any one tell me how to count males based on Value 'Mr. in "ashok, Mr. saini' column name is employee name

Count({$<[EMPLOYEE NAME]={"*Mr*"}>}[EMPLOYEE NAME])

5 Replies
martinpohl
Valued Contributor II

Re: can any one tell me how to count males based on Value 'Mr. in "ashok, Mr. saini' column name is employee name

Hello,

you can use

Count({<[EMPLOYEE NAME]={'*Mr.*'}>}[EMPLOYEE NAME])

Set Analysis is case sensitive, so if not all values are in same cases, create a field with upper() and change to

Count({<[EMPLOYEE NAME]={'*MR.*'}>}[EMPLOYEE NAME])

regards

vvvvvvizard
Contributor III

Re: can any one tell me how to count males based on Value 'Mr. in "ashok, Mr. saini' column name is employee name

Count({$<[EMPLOYEE NAME]={"*Mr*"}>}[EMPLOYEE NAME])

antoniotiman
Honored Contributor III

Re: can any one tell me how to count males based on Value 'Mr. in "ashok, Mr. saini' column name is employee name

Try this

Count({<[EMPLOYEE NAME]={"=WildMatch([EMPLOYEE NAME],'*MR*') > 0"}>}[EMPLOYEE NAME])

atkinsow
Valued Contributor II

Re: can any one tell me how to count males based on Value 'Mr. in "ashok, Mr. saini' column name is employee name

Try

Count({<[EMPLOYEE NAME]={"$(=WildMatch([EMPLOYEE NAME],'*MR*')) "}> }>}[EMPLOYEE NAME])

Not applicable

Re: can any one tell me how to count males based on Value 'Mr. in "ashok, Mr. saini' column name is employee name

It worked Than you very much for your suggestion