topic Re: Standard deviation for table. in QlikView https://community.qlik.com/t5/QlikView/Standard-deviation-for-table/m-p/377509#M1167891 <HTML><HEAD></HEAD><BODY><P>Hi Kiran, Thanks for response. Let me to take a step back and try to check my requirement again.</P></BODY></HTML> Tue, 14 Aug 2012 13:10:12 GMT 2012-08-14T13:10:12Z Standard deviation for table. https://community.qlik.com/t5/QlikView/Standard-deviation-for-table/m-p/377507#M1167889 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to calculate of standard deviation on column Type for every date. But I am not able to use stdev function. It just gives, empty boxes.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Type</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Number of days</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Count</STRONG></SPAN></TH></TR><TR><TD>CC</TD><TD>11</TD><TD>1-Aug-2012</TD><TD>1</TD></TR><TR><TD>CC</TD><TD>16</TD><TD>2-Aug-2012</TD><TD>1</TD></TR><TR><TD>CC</TD><TD>11</TD><TD>3-Aug-2012</TD><TD>1</TD></TR><TR><TD>CC</TD><TD>11</TD><TD>2-Aug-2012</TD><TD>1</TD></TR><TR><TD>DD</TD><TD>11</TD><TD>1-Aug-2012</TD><TD>1</TD></TR><TR><TD>DD</TD><TD>11</TD><TD>1-Aug-2012</TD><TD>1</TD></TR><TR><TD>DD</TD><TD>16</TD><TD>1-Aug-2012</TD><TD>1</TD></TR><TR><TD>DD</TD><TD>16</TD><TD>1-Aug-2012</TD><TD>1</TD></TR><TR><TD>DD</TD><TD>31</TD><TD>2-Aug-2012</TD><TD>1</TD></TR><TR><TD>DD</TD><TD>31</TD><TD>2-Aug-2012</TD><TD>1</TD></TR><TR><TD>DD</TD><TD>31</TD><TD>3-Aug-2012</TD><TD>1</TD></TR><TR><TD>DD</TD><TD>31</TD><TD>3-Aug-2012</TD><TD>1</TD></TR><TR><TD>EE</TD><TD>6</TD><TD>2-Aug-2012</TD><TD>1</TD></TR><TR><TD>EE</TD><TD>6</TD><TD>2-Aug-2012</TD><TD>1</TD></TR><TR><TD>EE</TD><TD>6</TD><TD>2-Aug-2012</TD><TD>1</TD></TR><TR><TD>EE</TD><TD>6</TD><TD>2-Aug-2012</TD><TD>1</TD></TR><TR><TD>EE</TD><TD>6</TD><TD>3-Aug-2012</TD><TD>1</TD></TR><TR><TD>EE</TD><TD>11</TD><TD>3-Aug-2012</TD><TD>1</TD></TR><TR><TD>EE</TD><TD>31</TD><TD>2-Aug-2012</TD><TD>1</TD></TR><TR><TD>EE</TD><TD>31</TD><TD>2-Aug-2012</TD><TD>1</TD></TR></TBODY></TABLE><P></P><P></P><P>I tried to create table with Type, Number of Days, Date, Sum(Count), stddev(Aggr(Sum(Count),Type,Number of Days).</P><P></P><P>But stddev function is showing empty values.</P><P></P><P>Any advice how to make it work?</P><P></P><P>Thanks in advance for your help.</P></BODY></HTML> Mon, 13 Aug 2012 20:40:13 GMT https://community.qlik.com/t5/QlikView/Standard-deviation-for-table/m-p/377507#M1167889 2012-08-13T20:40:13Z Re: Standard deviation for table. https://community.qlik.com/t5/QlikView/Standard-deviation-for-table/m-p/377508#M1167890 <HTML><HEAD></HEAD><BODY><P>Hi Andre,</P><P></P><P>Stddev is a group function ie, needs more than one value for input. In the above expression only one unique value exists for each type and number of days; equivalent of saying stddev(1) and hence no stddev. May be you need to articulate the functional need of stddev for me to help.</P><P></P><P>Regards,</P><P>Kiran.</P></BODY></HTML> Tue, 14 Aug 2012 01:33:50 GMT https://community.qlik.com/t5/QlikView/Standard-deviation-for-table/m-p/377508#M1167890 2012-08-14T01:33:50Z Re: Standard deviation for table. https://community.qlik.com/t5/QlikView/Standard-deviation-for-table/m-p/377509#M1167891 <HTML><HEAD></HEAD><BODY><P>Hi Kiran, Thanks for response. Let me to take a step back and try to check my requirement again.</P></BODY></HTML> Tue, 14 Aug 2012 13:10:12 GMT https://community.qlik.com/t5/QlikView/Standard-deviation-for-table/m-p/377509#M1167891 2012-08-14T13:10:12Z