Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Head Count

Hello Friends,

Please provide me solution of Headcount as below metioned:

Example: Director(1)-----> ABP(5)---->Teamlead(10) 

Can you please help to me??

Regards

Ravi Gupta

4 Replies
jvitantonio
Specialist III
Specialist III

count(total yourField)

Not applicable
Author

Thanks for reply.

  Can you Please show data in Hiericahlical preseation like this:

Director(1)-----> ABP(5)---->Teamlead(10)

Regards

Ravi Gupta

jvitantonio
Specialist III
Specialist III

i don't know how your model is but put your hierarchy in a pivot table, and then put the count() into the expression.

hic
Former Employee
Former Employee

I assume that you want to model a staff hiererchy. In the attached files you will find a very simple staff hierarchy, loaded into QlikView using the Hierarchy prefix and displayed using the tree-view list box.

/HIC