topic Re: Overall Average and StDev from table in QlikView https://community.qlik.com/t5/QlikView/Overall-Average-and-StDev-from-table/m-p/1138778#M887764 <HTML><HEAD></HEAD><BODY><P>See this blog post: <A href="https://community.qlik.com/qlik-blogpost/3088">QlikView Control (SPC) Chart</A></P></BODY></HTML> Fri, 02 Sep 2016 15:30:10 GMT Gysbert_Wassenaar 2016-09-02T15:30:10Z Overall Average and StDev from table https://community.qlik.com/t5/QlikView/Overall-Average-and-StDev-from-table/m-p/1138777#M887763 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I've got the below table which is the performance by person by hour in a day.&nbsp; I'm trying to get the average and stdev by person and hour.</P><P><IMG __jive_id="136374" alt="Tbl.png" class="jive-image image-1" height="117" src="https://community.qlik.com/legacyfs/online/136374_Tbl.png" style="height: 117px; width: 771.702px;" width="772" /></P><P></P><P>What I want to get via set analysis is the average and stdev per person per hour for the whole table.</P><P></P><P>In the above table the total is 1408.4 and the average is 28.74.&nbsp; The tricky thing in this is the hour is part of a drill down group so goes Month / Day / Hour and the Person is based on another drill down so goes Location / Manager / Legal Name.</P><P></P><P>The ultimate output i'm looking to produce is the below chart showing upper and lower control limits based on the above data table.</P><P><IMG __jive_id="136375" alt="chrt.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/136375_chrt.png" style="height: 282px; width: 620px;" /></P><P>Many thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Overall-Average-and-StDev-from-table/m-p/1138777#M887763 farnsworth 2020-11-25T16:16:04Z Re: Overall Average and StDev from table https://community.qlik.com/t5/QlikView/Overall-Average-and-StDev-from-table/m-p/1138778#M887764 <HTML><HEAD></HEAD><BODY><P>See this blog post: <A href="https://community.qlik.com/qlik-blogpost/3088">QlikView Control (SPC) Chart</A></P></BODY></HTML> Fri, 02 Sep 2016 15:30:10 GMT https://community.qlik.com/t5/QlikView/Overall-Average-and-StDev-from-table/m-p/1138778#M887764 Gysbert_Wassenaar 2016-09-02T15:30:10Z