5 Replies Latest reply: Jan 28, 2014 5:35 PM by Burcu Agar RSS

    Using STDEV and AVG with AGGR

      I have a table with item numbers, date and demand for those items, from which I am trying to calculate average and standard deviation of monthly demand.

       

      I loaded the table from MySql and created "MonthYear" with MonthName in the script.

       

      I used item number as dimension and avg(aggr(sum(SalesQty),MonthYear))and Stdev(aggr(sum(SalesQty),MonthYear)) for expressions . Both of them result in null value.

       

      I was able to calculate monthly average with this formula: sum(SalesQty)/Count(distinct(MonthYear)) however, I couldn't get around the stdev calculation. How can I formulate the calculation of std dev of sum of monthly demand in qlikview?


      Any help is appreciated.


      Thank you,