topic Head Count in QlikView https://community.qlik.com/t5/QlikView/Head-Count/m-p/369088#M137205 <HTML><HEAD></HEAD><BODY><P>i don't know how your model is but put your hierarchy in a pivot table, and then put the count() into the expression.</P></BODY></HTML> Mon, 26 Mar 2012 12:24:25 GMT jvitantonio 2012-03-26T12:24:25Z Head Count https://community.qlik.com/t5/QlikView/Head-Count/m-p/369085#M137202 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>Please provide me solution of Headcount as below metioned:</P><P></P><P>Example: Director(1)-----&gt; ABP(5)----&gt;Teamlead(10)&nbsp; </P><P></P><P>Can you please help to me??</P><P></P><P></P><P>Regards</P><P>Ravi Gupta</P></BODY></HTML> Mon, 26 Mar 2012 12:05:46 GMT https://community.qlik.com/t5/QlikView/Head-Count/m-p/369085#M137202 2012-03-26T12:05:46Z Head Count https://community.qlik.com/t5/QlikView/Head-Count/m-p/369086#M137203 <HTML><HEAD></HEAD><BODY><P>count(total yourField)</P></BODY></HTML> Mon, 26 Mar 2012 12:11:06 GMT https://community.qlik.com/t5/QlikView/Head-Count/m-p/369086#M137203 jvitantonio 2012-03-26T12:11:06Z Head Count https://community.qlik.com/t5/QlikView/Head-Count/m-p/369087#M137204 <HTML><HEAD></HEAD><BODY><P> Thanks for reply.</P><P></P><P>&nbsp; Can you Please show data in Hiericahlical preseation like this:</P><P></P><P> Director(1)-----&gt; ABP(5)----&gt;Teamlead(10) </P><P></P><P></P><P>Regards</P><P>Ravi Gupta</P></BODY></HTML> Mon, 26 Mar 2012 12:16:11 GMT https://community.qlik.com/t5/QlikView/Head-Count/m-p/369087#M137204 2012-03-26T12:16:11Z Head Count https://community.qlik.com/t5/QlikView/Head-Count/m-p/369088#M137205 <HTML><HEAD></HEAD><BODY><P>i don't know how your model is but put your hierarchy in a pivot table, and then put the count() into the expression.</P></BODY></HTML> Mon, 26 Mar 2012 12:24:25 GMT https://community.qlik.com/t5/QlikView/Head-Count/m-p/369088#M137205 jvitantonio 2012-03-26T12:24:25Z Re: Head Count https://community.qlik.com/t5/QlikView/Head-Count/m-p/369089#M137206 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>/HIC</P></BODY></HTML> Mon, 26 Mar 2012 12:25:21 GMT https://community.qlik.com/t5/QlikView/Head-Count/m-p/369089#M137206 hic 2012-03-26T12:25:21Z