topic sum stdev in QlikView https://community.qlik.com/t5/QlikView/sum-stdev/m-p/460406#M171879 <HTML><HEAD></HEAD><BODY><P>I have the following formula. It takes the stdev of fund return for the last three years. Now I need to sum the result of the formula. I tried sum&nbsp; and aggr(sum)) none of which seem to work. It either returns 0 or null.</P><P></P><P> stdev(&nbsp; {&lt;dte_monthname={'&gt;$(=date((max(dte_monthname))-365*3,'YYYY-MM-DD')) &lt;=$(=date(max(dte_monthname),'YYYY-MM-DD'))'}&gt;} aggr(</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sum( weighted_net_profit) /sum(market_system_weight_current_normalized) , dte_monthname ))</P></BODY></HTML> Wed, 20 Mar 2013 13:04:51 GMT 2013-03-20T13:04:51Z sum stdev https://community.qlik.com/t5/QlikView/sum-stdev/m-p/460406#M171879 <HTML><HEAD></HEAD><BODY><P>I have the following formula. It takes the stdev of fund return for the last three years. Now I need to sum the result of the formula. I tried sum&nbsp; and aggr(sum)) none of which seem to work. It either returns 0 or null.</P><P></P><P> stdev(&nbsp; {&lt;dte_monthname={'&gt;$(=date((max(dte_monthname))-365*3,'YYYY-MM-DD')) &lt;=$(=date(max(dte_monthname),'YYYY-MM-DD'))'}&gt;} aggr(</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sum( weighted_net_profit) /sum(market_system_weight_current_normalized) , dte_monthname ))</P></BODY></HTML> Wed, 20 Mar 2013 13:04:51 GMT https://community.qlik.com/t5/QlikView/sum-stdev/m-p/460406#M171879 2013-03-20T13:04:51Z