topic Need Clarification on Monthly Average Spent in QlikView https://community.qlik.com/t5/QlikView/Need-Clarification-on-Monthly-Average-Spent/m-p/425372#M158440 <HTML><HEAD></HEAD><BODY><P>Hello Frineds</P><P></P><P>I would like to find the Monthly Average spent for last year and Current Year, I have written the expression as in the below but its showing wrorng resutls.</P><P></P><P>Could you please any one suggest me, where I am making a mistake in the expression.</P><P></P><P><STRONG>=Num(Avg({$&lt;ShipmentMonth,ShipmentYear={$(=max(ShipmentYear)-1)}&gt;} [Rupees]),'# ##0')</STRONG></P><P></P><P><STRONG>=Num(Avg({$&lt;ShipmentMonth,ShipmentYear={$(=max(ShipmentYear))}&gt;} [Rupees]),'# ##0')</STRONG></P><P></P><P>Regards</P><P></P><P>Ammu<STRONG><BR /></STRONG></P></BODY></HTML> Wed, 16 Jan 2013 06:29:39 GMT 2013-01-16T06:29:39Z Need Clarification on Monthly Average Spent https://community.qlik.com/t5/QlikView/Need-Clarification-on-Monthly-Average-Spent/m-p/425372#M158440 <HTML><HEAD></HEAD><BODY><P>Hello Frineds</P><P></P><P>I would like to find the Monthly Average spent for last year and Current Year, I have written the expression as in the below but its showing wrorng resutls.</P><P></P><P>Could you please any one suggest me, where I am making a mistake in the expression.</P><P></P><P><STRONG>=Num(Avg({$&lt;ShipmentMonth,ShipmentYear={$(=max(ShipmentYear)-1)}&gt;} [Rupees]),'# ##0')</STRONG></P><P></P><P><STRONG>=Num(Avg({$&lt;ShipmentMonth,ShipmentYear={$(=max(ShipmentYear))}&gt;} [Rupees]),'# ##0')</STRONG></P><P></P><P>Regards</P><P></P><P>Ammu<STRONG><BR /></STRONG></P></BODY></HTML> Wed, 16 Jan 2013 06:29:39 GMT https://community.qlik.com/t5/QlikView/Need-Clarification-on-Monthly-Average-Spent/m-p/425372#M158440 2013-01-16T06:29:39Z Re: Need Clarification on Monthly Average Spent https://community.qlik.com/t5/QlikView/Need-Clarification-on-Monthly-Average-Spent/m-p/425373#M158441 <HTML><HEAD></HEAD><BODY><P>Hi,,</P><P>one thing i found is theat use year(today()) for current Date...</P></BODY></HTML> Wed, 16 Jan 2013 06:44:05 GMT https://community.qlik.com/t5/QlikView/Need-Clarification-on-Monthly-Average-Spent/m-p/425373#M158441 sujeetsingh 2013-01-16T06:44:05Z Re: Need Clarification on Monthly Average Spent https://community.qlik.com/t5/QlikView/Need-Clarification-on-Monthly-Average-Spent/m-p/425374#M158442 <HTML><HEAD></HEAD><BODY><P>I don't see any direct wrongs with your expressions, except the last format definition that have a incorrect space (<STRONG style="background-color: #ffffff; color: #737373; font-family: Arial;">'# ##0'</STRONG>) to render correctly (maybe it is my browser/forum that makes that conversion) <STRONG style="background-color: #ffffff; color: #737373; font-family: Arial;"> </STRONG></P><P></P><P>Be aware that your max(shipmentYear) will change whenever you make any selections in your data.</P></BODY></HTML> Wed, 16 Jan 2013 07:02:37 GMT https://community.qlik.com/t5/QlikView/Need-Clarification-on-Monthly-Average-Spent/m-p/425374#M158442 Vegar 2013-01-16T07:02:37Z