topic Help Set Analysis Expressions in QlikView https://community.qlik.com/t5/QlikView/Help-Set-Analysis-Expressions/m-p/367944#M136831 <HTML><HEAD></HEAD><BODY><P>Hellow </P><P></P><P>I have this expressions the objetive is get a % of Acumalates sales / acumulates sales in a set off products</P><P></P><P></P><P></P><P>=RangeSum(Above(sum({$&lt;[Comision - Año]={$(=max(Año))}&gt;} [Comision - Ventas]),Rowno(Total,0))) / RangeSum(Above(sum({$&lt;[Comision - Año]={$(=max(Año))}, [Comision - Division] = {'DIVISION I','DIVISION II','DIVISION III','DIVISION VII'}}&gt;} [Comision - Ventas]),Rowno(Total,0)))</P><P></P><P></P><P></P><P>The result is well but I need to totalize this % in the line off totals</P><P></P><P>Thanks alot.</P></BODY></HTML> Wed, 25 Apr 2012 15:34:22 GMT 2012-04-25T15:34:22Z Help Set Analysis Expressions https://community.qlik.com/t5/QlikView/Help-Set-Analysis-Expressions/m-p/367944#M136831 <HTML><HEAD></HEAD><BODY><P>Hellow </P><P></P><P>I have this expressions the objetive is get a % of Acumalates sales / acumulates sales in a set off products</P><P></P><P></P><P></P><P>=RangeSum(Above(sum({$&lt;[Comision - Año]={$(=max(Año))}&gt;} [Comision - Ventas]),Rowno(Total,0))) / RangeSum(Above(sum({$&lt;[Comision - Año]={$(=max(Año))}, [Comision - Division] = {'DIVISION I','DIVISION II','DIVISION III','DIVISION VII'}}&gt;} [Comision - Ventas]),Rowno(Total,0)))</P><P></P><P></P><P></P><P>The result is well but I need to totalize this % in the line off totals</P><P></P><P>Thanks alot.</P></BODY></HTML> Wed, 25 Apr 2012 15:34:22 GMT https://community.qlik.com/t5/QlikView/Help-Set-Analysis-Expressions/m-p/367944#M136831 2012-04-25T15:34:22Z