topic Re: Count in Dimension in QlikView https://community.qlik.com/t5/QlikView/Count-in-Dimension/m-p/679019#M1068621 <HTML><HEAD></HEAD><BODY><P>Dear Tracy,</P><P></P><P>Use below code in dimension</P><P></P><P>=Aggr(count(Emp_No),Company)</P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/65586_pastedImage_0.png" style="width: auto; height: auto;" /></P><P></P><P>Thanks,</P><P>Mukram</P></BODY></HTML> Sun, 31 Aug 2014 08:25:54 GMT mdmukramali 2014-08-31T08:25:54Z Count in Dimension https://community.qlik.com/t5/QlikView/Count-in-Dimension/m-p/679017#M1068619 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P>Can someone help to explain why count function for "No. of Employee" not work in Dimension ?.</P><P></P><P>Thank you very much</P><P>Tracy</P></BODY></HTML> Sun, 31 Aug 2014 08:16:01 GMT https://community.qlik.com/t5/QlikView/Count-in-Dimension/m-p/679017#M1068619 tracycrown 2014-08-31T08:16:01Z Re: Count in Dimension https://community.qlik.com/t5/QlikView/Count-in-Dimension/m-p/679018#M1068620 <HTML><HEAD></HEAD><BODY><P>Maybe the aggr() function helps</P></BODY></HTML> Sun, 31 Aug 2014 08:18:32 GMT https://community.qlik.com/t5/QlikView/Count-in-Dimension/m-p/679018#M1068620 MarcoWedel 2014-08-31T08:18:32Z Re: Count in Dimension https://community.qlik.com/t5/QlikView/Count-in-Dimension/m-p/679019#M1068621 <HTML><HEAD></HEAD><BODY><P>Dear Tracy,</P><P></P><P>Use below code in dimension</P><P></P><P>=Aggr(count(Emp_No),Company)</P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/65586_pastedImage_0.png" style="width: auto; height: auto;" /></P><P></P><P>Thanks,</P><P>Mukram</P></BODY></HTML> Sun, 31 Aug 2014 08:25:54 GMT https://community.qlik.com/t5/QlikView/Count-in-Dimension/m-p/679019#M1068621 mdmukramali 2014-08-31T08:25:54Z Re: Count in Dimension https://community.qlik.com/t5/QlikView/Count-in-Dimension/m-p/679020#M1068622 <HTML><HEAD></HEAD><BODY><P>Here you have my proposal</P></BODY></HTML> Sun, 31 Aug 2014 08:26:49 GMT https://community.qlik.com/t5/QlikView/Count-in-Dimension/m-p/679020#M1068622 ecolomer 2014-08-31T08:26:49Z