topic Re: stdev in straight table in QlikView https://community.qlik.com/t5/QlikView/stdev-in-straight-table/m-p/551792#M1142374 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Sum() will aggregate over all the possible values for the dimensions in your straight table. So for those dimensions you would be calculating a single number. Calculating the standard deviation for a sample size of 1 will not work, of course.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Stdev((a+b)/c) might work depending on your data model.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">More likely you will have to use an aggregation such as</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Stdev(Aggr((Sum(a)+Sum(b))/Sum(c),Dimension1,Dimension2))<BR /></SPAN></P></BODY></HTML> Sun, 22 Sep 2013 19:41:47 GMT 2013-09-22T19:41:47Z stdev in straight table https://community.qlik.com/t5/QlikView/stdev-in-straight-table/m-p/551791#M1142373 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt; background: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">Hey all,</SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"> </SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">i'm trying to use the stdev() func on a straight table, my formula is :</SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">stdev((sum(a)+sum(b))/sum(c))</SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"> </SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">but its not working&nbsp; .....</SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">any ideas ?</SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"> </SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"> </SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">thanks</SPAN></P><P style="background-color: white;"><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">J</SPAN></P></BODY></HTML> Sun, 22 Sep 2013 12:27:44 GMT https://community.qlik.com/t5/QlikView/stdev-in-straight-table/m-p/551791#M1142373 Anonymous 2013-09-22T12:27:44Z Re: stdev in straight table https://community.qlik.com/t5/QlikView/stdev-in-straight-table/m-p/551792#M1142374 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Sum() will aggregate over all the possible values for the dimensions in your straight table. So for those dimensions you would be calculating a single number. Calculating the standard deviation for a sample size of 1 will not work, of course.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Stdev((a+b)/c) might work depending on your data model.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">More likely you will have to use an aggregation such as</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Stdev(Aggr((Sum(a)+Sum(b))/Sum(c),Dimension1,Dimension2))<BR /></SPAN></P></BODY></HTML> Sun, 22 Sep 2013 19:41:47 GMT https://community.qlik.com/t5/QlikView/stdev-in-straight-table/m-p/551792#M1142374 2013-09-22T19:41:47Z