topic Re: Average grouping by serial number in script, how to? in QlikView https://community.qlik.com/t5/QlikView/Average-grouping-by-serial-number-in-script-how-to/m-p/591154#M681037 <HTML><HEAD></HEAD><BODY><P>Please use Left Join instead of Join </P></BODY></HTML> Thu, 17 Apr 2014 12:59:29 GMT 2014-04-17T12:59:29Z Average grouping by serial number in script, how to? https://community.qlik.com/t5/QlikView/Average-grouping-by-serial-number-in-script-how-to/m-p/591152#M681035 <HTML><HEAD></HEAD><BODY><P>Hey guys,</P><P></P><P>I have a field called "Serial Number", and another one called "Flight time", I would like to make a Flight Time average per serial number, in the script...</P><P></P><P>How do I create that??</P></BODY></HTML> Thu, 17 Apr 2014 12:14:31 GMT https://community.qlik.com/t5/QlikView/Average-grouping-by-serial-number-in-script-how-to/m-p/591152#M681035 2014-04-17T12:14:31Z Re: Average grouping by serial number in script, how to? https://community.qlik.com/t5/QlikView/Average-grouping-by-serial-number-in-script-how-to/m-p/591153#M681036 <HTML><HEAD></HEAD><BODY><P>MainTable:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Serial Number]</P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Flight time]</P><P>&nbsp;&nbsp;&nbsp;&nbsp; anotherField1</P><P>&nbsp;&nbsp;&nbsp;&nbsp; anotherField2</P><P>From TableName;</P><P></P><P>Join</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Serial Number]</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Avg[Flight time] as AvgFlightTime</P><P>Resident MainTable</P><P>Group By [Serial Number];</P></BODY></HTML> Thu, 17 Apr 2014 12:16:35 GMT https://community.qlik.com/t5/QlikView/Average-grouping-by-serial-number-in-script-how-to/m-p/591153#M681036 MK_QSL 2014-04-17T12:16:35Z Re: Average grouping by serial number in script, how to? https://community.qlik.com/t5/QlikView/Average-grouping-by-serial-number-in-script-how-to/m-p/591154#M681037 <HTML><HEAD></HEAD><BODY><P>Please use Left Join instead of Join </P></BODY></HTML> Thu, 17 Apr 2014 12:59:29 GMT https://community.qlik.com/t5/QlikView/Average-grouping-by-serial-number-in-script-how-to/m-p/591154#M681037 2014-04-17T12:59:29Z