topic Standard Deviation in QlikView https://community.qlik.com/t5/QlikView/Standard-Deviation/m-p/300469#M581518 <HTML><HEAD></HEAD><BODY><P>I need help with the folowing problem</P><P style="text-align: left;"><BR />I have a file with sales quantity per week.&nbsp;&nbsp; I now need to calculate the standard deviation where the sales quantity is grouped by a number of weeks. The number of weeks is entered in to a input field by the user. </P><PRE __default_attr="html" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>&lt;/BR&gt;</P></PRE><P>So i have week 1 10 pcs&nbsp; week 2 20 pcs week 3 5 pcs&nbsp; week 4 25 pcs.&nbsp; If the user inputs 2 weeks my calculation of the standard deviation would be like&nbsp; stdev(30,30) </P><PRE __default_attr="html" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>&lt;/br&gt;</P></PRE><P>Peter</P></BODY></HTML> Wed, 14 Dec 2011 15:36:21 GMT 2011-12-14T15:36:21Z Standard Deviation https://community.qlik.com/t5/QlikView/Standard-Deviation/m-p/300469#M581518 <HTML><HEAD></HEAD><BODY><P>I need help with the folowing problem</P><P style="text-align: left;"><BR />I have a file with sales quantity per week.&nbsp;&nbsp; I now need to calculate the standard deviation where the sales quantity is grouped by a number of weeks. The number of weeks is entered in to a input field by the user. </P><PRE __default_attr="html" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>&lt;/BR&gt;</P></PRE><P>So i have week 1 10 pcs&nbsp; week 2 20 pcs week 3 5 pcs&nbsp; week 4 25 pcs.&nbsp; If the user inputs 2 weeks my calculation of the standard deviation would be like&nbsp; stdev(30,30) </P><PRE __default_attr="html" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>&lt;/br&gt;</P></PRE><P>Peter</P></BODY></HTML> Wed, 14 Dec 2011 15:36:21 GMT https://community.qlik.com/t5/QlikView/Standard-Deviation/m-p/300469#M581518 2011-12-14T15:36:21Z