topic Re: Count Function in QlikView

Count Function

Tue, 07 Oct 2014 05:31:35 GMT

Hi All

I currently have a field with concatenated fields consisting of Job Grades.

I would like to have a count function in the field to indicate the number of each job grade found in the field.

e.g Current:

[All Job Grades]

Senior Manager| Assistant Manager| Accociate Director| Senior Manager

Desired:

[All Job Grades]

Senior Manager(2)| Assistant Manager(1)| Associate Director(1)

How can I do this?

Re: Count Function

jyothish8807 — Tue, 07 Oct 2014 05:35:15 GMT

Hi Tumelo,

Take [All Job Grade] as dimension in straight chart.

Exp:

count([All Job Grade]

Hope it works.

Regards

Re: Count Function

sushil353 — Tue, 07 Oct 2014 05:37:47 GMT

Hi,

your data set is not clear.. please upload some sample data..

Other wise you can try the expression below.

='Senior Manager'&count({<[All Job Grades]={'Senior Manager'}>}emp_id)&'| Assistant Manager '&count({<[All Job Grades]={'Assistant Manager'}>}emp_id)& ' | Associate Director '&count({<[All Job Grades]={'Associate Director'}>}emp_id)

HTH

Sushil

Re: Count Function

anbu1984 — Tue, 07 Oct 2014 05:40:31 GMT

Check this qvw

Re: Count Function

jyothish8807 — Tue, 07 Oct 2014 05:41:22 GMT

Missed a closing bracket.

Exp:

count([All Job Grade])

Regards

Re: Count Function

Tue, 07 Oct 2014 05:56:50 GMT

Hi Everyone

Thanks a lot for all your responses. Anbu gave me the expression I'm looking for.

Thanks once again Anbu!