topic Re: Calculate Mean in QlikView https://community.qlik.com/t5/QlikView/Calculate-Mean/m-p/342463#M126514 <HTML><HEAD></HEAD><BODY><P>Count(Products)/ Count(distinct Persons)</P></BODY></HTML> Tue, 10 Jul 2012 08:07:18 GMT kji 2012-07-10T08:07:18Z Calculate Mean https://community.qlik.com/t5/QlikView/Calculate-Mean/m-p/342462#M126513 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have a table with some persons with a number of products connected to each person. How can i calculate the average number of products that persons have?</P><P></P><P>Example:</P><P></P><P>PERSONS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PRODUCTS</P><P>person1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; product1</P><P>person1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; product2</P><P>person1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; product3</P><P>person2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; product4</P><P>person3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; product5</P><P>person3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; product6</P><P>person4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; product7</P><P>person4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; product8</P><P></P><P>The average in this example should be 2 since person1 hase three products, person2 has one product and person3 and person4 has two products.</P><P>Please, how do i accomplish this in qlikview?</P><P></P><P>Thank you.</P></BODY></HTML> Tue, 10 Jul 2012 07:41:10 GMT https://community.qlik.com/t5/QlikView/Calculate-Mean/m-p/342462#M126513 2012-07-10T07:41:10Z Re: Calculate Mean https://community.qlik.com/t5/QlikView/Calculate-Mean/m-p/342463#M126514 <HTML><HEAD></HEAD><BODY><P>Count(Products)/ Count(distinct Persons)</P></BODY></HTML> Tue, 10 Jul 2012 08:07:18 GMT https://community.qlik.com/t5/QlikView/Calculate-Mean/m-p/342463#M126514 kji 2012-07-10T08:07:18Z Re: Calculate Mean https://community.qlik.com/t5/QlikView/Calculate-Mean/m-p/342464#M126515 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Tue, 10 Jul 2012 08:56:19 GMT https://community.qlik.com/t5/QlikView/Calculate-Mean/m-p/342464#M126515 2012-07-10T08:56:19Z