Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count Function


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?

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

5 Replies
jyothish8807
Master II
Master II

Hi Tumelo,

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

Exp:

count([All Job Grade]

Hope it works.

Regards

KC

Best Regards,
KC
sushil353
Master II
Master II

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

anbu1984
Master III
Master III

jyothish8807
Master II
Master II

Missed a closing bracket.

Exp:

count([All Job Grade])

Regards

KC

Best Regards,
KC
Not applicable


Hi Everyone

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

Thanks once again Anbu!