topic Help in set analysis in QlikView https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/464502#M173510 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>As I am trying to fine the sum of sales for the maxium year.</P><P></P><P>I tried the following but it throws a error.</P><P></P><P>=Sum({&lt;ShipmentYear={'$(=max(ShipmentYear))'&gt;}}[Sales])</P><P></P><P>Could you please help me..</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Sun, 25 Nov 2012 13:47:04 GMT 2012-11-25T13:47:04Z Help in set analysis https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/464502#M173510 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>As I am trying to fine the sum of sales for the maxium year.</P><P></P><P>I tried the following but it throws a error.</P><P></P><P>=Sum({&lt;ShipmentYear={'$(=max(ShipmentYear))'&gt;}}[Sales])</P><P></P><P>Could you please help me..</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Sun, 25 Nov 2012 13:47:04 GMT https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/464502#M173510 2012-11-25T13:47:04Z Re: Help in set analysis https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/464503#M173511 <HTML><HEAD></HEAD><BODY><P>Just a typo it seems. Try:</P><P>=Sum({&lt;ShipmentYear={'$(=max(ShipmentYear))'<SPAN style="color: #ff0000;"><STRONG>}&gt;}</STRONG></SPAN>[Sales])</P></BODY></HTML> Sun, 25 Nov 2012 13:47:41 GMT https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/464503#M173511 Gysbert_Wassenaar 2012-11-25T13:47:41Z Re: Help in set analysis https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/464504#M173512 <HTML><HEAD></HEAD><BODY><P>Hello Gysbert,</P><P></P><P>Thanks a lot, it works, I tried this for the past 2 hours, came with a good solution.</P><P></P><P>Reagrds</P><P></P><P>Chriss</P></BODY></HTML> Sun, 25 Nov 2012 13:58:42 GMT https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/464504#M173512 2012-11-25T13:58:42Z