topic Re: Grouping in QlikView https://community.qlik.com/t5/QlikView/Grouping/m-p/1087991#M926263 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P><STRONG>Aggr(If(Sum(Score) &gt;= [Lower Score] and Sum(Score) &lt;= [Upper Score], Grade), Code, Grade)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121120_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Sun, 10 Apr 2016 17:08:55 GMT sunny_talwar 2016-04-10T17:08:55Z Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/1087990#M926262 <HTML><HEAD></HEAD><BODY><P>Dear sir / madam</P><P></P><P>Can someone help me to resolve the issue on Grade which is missing in table 2 attached ?.</P><P></P><P>Thank you</P><P>Tracy</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/1087990#M926262 tracycrown 2020-11-25T16:16:04Z Re: Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/1087991#M926263 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P><STRONG>Aggr(If(Sum(Score) &gt;= [Lower Score] and Sum(Score) &lt;= [Upper Score], Grade), Code, Grade)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121120_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Sun, 10 Apr 2016 17:08:55 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/1087991#M926263 sunny_talwar 2016-04-10T17:08:55Z Re: Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/1087992#M926264 <HTML><HEAD></HEAD><BODY><P>A script solution in the attachment</P><P></P><P><IMG alt="1.png" class="jive-image image-1" height="307" src="https://community.qlik.com/legacyfs/online/121123_1.png" style="height: 307.189px; width: 281px;" width="281" /></P></BODY></HTML> Sun, 10 Apr 2016 18:37:03 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/1087992#M926264 maxgro 2016-04-10T18:37:03Z