topic How to make an frequency distribution. in QlikView https://community.qlik.com/t5/QlikView/How-to-make-an-frequency-distribution/m-p/487014#M1139122 <HTML><HEAD></HEAD><BODY><P>Hi. I´m new using Qlikview and I have a few questions.</P><P></P><P>I have a list of names where several of these occur more than once. I want to be able to count the number of occurences of a name and make a bar chart with number of people on the y axis and number of times they occur on the x axis.</P><P>How do I do this? Any suggestions?</P><P></P><P>With kind regards!</P><P>/Hans</P></BODY></HTML> Fri, 27 Sep 2013 10:39:03 GMT 2013-09-27T10:39:03Z How to make an frequency distribution. https://community.qlik.com/t5/QlikView/How-to-make-an-frequency-distribution/m-p/487014#M1139122 <HTML><HEAD></HEAD><BODY><P>Hi. I´m new using Qlikview and I have a few questions.</P><P></P><P>I have a list of names where several of these occur more than once. I want to be able to count the number of occurences of a name and make a bar chart with number of people on the y axis and number of times they occur on the x axis.</P><P>How do I do this? Any suggestions?</P><P></P><P>With kind regards!</P><P>/Hans</P></BODY></HTML> Fri, 27 Sep 2013 10:39:03 GMT https://community.qlik.com/t5/QlikView/How-to-make-an-frequency-distribution/m-p/487014#M1139122 2013-09-27T10:39:03Z Re: How to make an frequency distribution. https://community.qlik.com/t5/QlikView/How-to-make-an-frequency-distribution/m-p/487015#M1139123 <HTML><HEAD></HEAD><BODY><P>example:&nbsp; </P><P></P><P></P><P>Dimension:&nbsp;&nbsp; Name</P><P>Expression: Count(Name)</P></BODY></HTML> Fri, 27 Sep 2013 13:22:21 GMT https://community.qlik.com/t5/QlikView/How-to-make-an-frequency-distribution/m-p/487015#M1139123 2013-09-27T13:22:21Z Re: How to make an frequency distribution. https://community.qlik.com/t5/QlikView/How-to-make-an-frequency-distribution/m-p/487016#M1139124 <HTML><HEAD></HEAD><BODY><P>Using name as an dimension will just give how many times name occur. What I want to be able to show is how many people occur 1 time, 2 times, 3 times and so fourth.</P><P>So on the y axis number of people and on the x axis 1, 2, 3,.....</P><P><BR /> </P></BODY></HTML> Mon, 30 Sep 2013 08:16:08 GMT https://community.qlik.com/t5/QlikView/How-to-make-an-frequency-distribution/m-p/487016#M1139124 2013-09-30T08:16:08Z Re: How to make an frequency distribution. https://community.qlik.com/t5/QlikView/How-to-make-an-frequency-distribution/m-p/487017#M1139125 <HTML><HEAD></HEAD><BODY><P>Found the solution.</P><P></P><P>Using</P><P>Dimension: Aggr(Count(Name), Name)</P><P>Expression: Count(distinct(Name))</P><P>/Hans</P></BODY></HTML> Mon, 30 Sep 2013 08:46:46 GMT https://community.qlik.com/t5/QlikView/How-to-make-an-frequency-distribution/m-p/487017#M1139125 2013-09-30T08:46:46Z