topic How to display descriptive statistics per field in QlikView https://community.qlik.com/t5/QlikView/How-to-display-descriptive-statistics-per-field/m-p/1209539#M388213 <HTML><HEAD></HEAD><BODY><P>I want to display a table that tells me the average, sum, count, etc. for several fields in my data. Is there an easy, general way to do this?</P><P></P><P>For example, I have 1 row per person, followed by columns for various values like age, height, weight. I want to know summary for those columns to understand how many people have data and what the avg/min/max is.</P><P></P><P>e.g. 1000 people</P><P>995 have a value for age; 40/18/65 avg/min/max</P><P>800 have height; 160/140/180 cm avg/min/max</P><P>etc...</P><P></P><P>resulting table has column 1 = field name, column 2= count, 3=avg, 4=min, 5=max</P></BODY></HTML> Fri, 04 Nov 2016 17:38:36 GMT daveatkins 2016-11-04T17:38:36Z How to display descriptive statistics per field https://community.qlik.com/t5/QlikView/How-to-display-descriptive-statistics-per-field/m-p/1209539#M388213 <HTML><HEAD></HEAD><BODY><P>I want to display a table that tells me the average, sum, count, etc. for several fields in my data. Is there an easy, general way to do this?</P><P></P><P>For example, I have 1 row per person, followed by columns for various values like age, height, weight. I want to know summary for those columns to understand how many people have data and what the avg/min/max is.</P><P></P><P>e.g. 1000 people</P><P>995 have a value for age; 40/18/65 avg/min/max</P><P>800 have height; 160/140/180 cm avg/min/max</P><P>etc...</P><P></P><P>resulting table has column 1 = field name, column 2= count, 3=avg, 4=min, 5=max</P></BODY></HTML> Fri, 04 Nov 2016 17:38:36 GMT https://community.qlik.com/t5/QlikView/How-to-display-descriptive-statistics-per-field/m-p/1209539#M388213 daveatkins 2016-11-04T17:38:36Z Re: How to display descriptive statistics per field https://community.qlik.com/t5/QlikView/How-to-display-descriptive-statistics-per-field/m-p/1209540#M388214 <HTML><HEAD></HEAD><BODY><P>try with statistic box:</P><P></P><P><IMG alt="Unbenannt.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/142999_Unbenannt.png" style="height: 467px; width: 620px;" /></P><P></P><P>hope this helps</P></BODY></HTML> Fri, 04 Nov 2016 18:37:19 GMT https://community.qlik.com/t5/QlikView/How-to-display-descriptive-statistics-per-field/m-p/1209540#M388214 Frank_Hartmann 2016-11-04T18:37:19Z