topic Populate Acumulation in diferent dimension in QlikView https://community.qlik.com/t5/QlikView/Populate-Acumulation-in-diferent-dimension/m-p/248934#M94669 <HTML><HEAD></HEAD><BODY><P>See the example attach</P></BODY></HTML> Thu, 02 Feb 2012 16:37:44 GMT jolivares 2012-02-02T16:37:44Z Populate Acumulation in diferent dimension https://community.qlik.com/t5/QlikView/Populate-Acumulation-in-diferent-dimension/m-p/248934#M94669 <HTML><HEAD></HEAD><BODY><P>See the example attach</P></BODY></HTML> Thu, 02 Feb 2012 16:37:44 GMT https://community.qlik.com/t5/QlikView/Populate-Acumulation-in-diferent-dimension/m-p/248934#M94669 jolivares 2012-02-02T16:37:44Z Populate Acumulation in diferent dimension https://community.qlik.com/t5/QlikView/Populate-Acumulation-in-diferent-dimension/m-p/248935#M94670 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You have a couple of things wrong with your expression:</P><P></P><P>&nbsp;&nbsp; RangeSum(Above(total Sum(Value),0,RowNo(TOTAL)))</P><P></P><P>Now, the only problem is that it will not aggregate if the dimension is collapsed.&nbsp; This is because if it is collapsed, the Above(Total Sum(Value)) doesn't make any sense - there is no row above.</P><P></P><P>Regards,</P><P></P><P></P><P><BR />Stephen</P></BODY></HTML> Thu, 02 Feb 2012 17:11:54 GMT https://community.qlik.com/t5/QlikView/Populate-Acumulation-in-diferent-dimension/m-p/248935#M94670 stephencredmond 2012-02-02T17:11:54Z