topic Comparing monthly values to average - using Aggr() ? in QlikView https://community.qlik.com/t5/QlikView/Comparing-monthly-values-to-average-using-Aggr/m-p/376753#M1168925 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I would like to create an expression comparing the value of an expression for a month to the average (or sum) of the same expression for all months.</P><P></P><P>I think I should use an aggr function but cannot manage it.</P><P></P><P>Maybe the Excel file will be more explicit (in the yellow column, the expression I'd like to create).</P><P></P><P>I made various tries with aggr(sum(spacecrafts),NumMonth)/aggr(avg(inhabitants),NumMonth), Aggr(sum(spacecrafts),NumMonth,Planet)... but I allways get 1 as result. </P><P></P><P>If someone could help me understand how to do that...</P><P></P><P>Regards</P><P></P><P>Olivier</P></BODY></HTML> Thu, 09 Aug 2012 21:57:22 GMT 2012-08-09T21:57:22Z Comparing monthly values to average - using Aggr() ? https://community.qlik.com/t5/QlikView/Comparing-monthly-values-to-average-using-Aggr/m-p/376753#M1168925 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I would like to create an expression comparing the value of an expression for a month to the average (or sum) of the same expression for all months.</P><P></P><P>I think I should use an aggr function but cannot manage it.</P><P></P><P>Maybe the Excel file will be more explicit (in the yellow column, the expression I'd like to create).</P><P></P><P>I made various tries with aggr(sum(spacecrafts),NumMonth)/aggr(avg(inhabitants),NumMonth), Aggr(sum(spacecrafts),NumMonth,Planet)... but I allways get 1 as result. </P><P></P><P>If someone could help me understand how to do that...</P><P></P><P>Regards</P><P></P><P>Olivier</P></BODY></HTML> Thu, 09 Aug 2012 21:57:22 GMT https://community.qlik.com/t5/QlikView/Comparing-monthly-values-to-average-using-Aggr/m-p/376753#M1168925 2012-08-09T21:57:22Z