topic Re: Calculating total in dimension in QlikView https://community.qlik.com/t5/QlikView/Calculating-total-in-dimension/m-p/873895#M653781 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=If(Aggr(Sum(TOTAL &lt;PROD_DT, REL_CD&gt; VALUE), REL_CD) &gt; 10000000, REL_CD))</STRONG></SPAN></P></BODY></HTML> Thu, 02 Jul 2015 16:01:08 GMT sunny_talwar 2015-07-02T16:01:08Z Calculating total in dimension https://community.qlik.com/t5/QlikView/Calculating-total-in-dimension/m-p/873894#M653780 <HTML><HEAD></HEAD><BODY><P>I am attempting to use this calculation in my dimension but it is not working:</P><P></P><P>if(sum(total &lt;PROD_DT, REL_CD&gt; VALUE) &gt; 10000000, REL_CD))</P><P></P><P>What I m trying to do is calculate a sum of 'VALUE' for each 'REL_CD' on a given 'PROD_DT' and only display that 'REL_CD' in the dimension if it's sum is greater than 10 million. Does anyone know why this is not working and if there is a way to successfully accomplish what I need?</P><P></P><P>Thank you</P></BODY></HTML> Thu, 02 Jul 2015 15:59:46 GMT https://community.qlik.com/t5/QlikView/Calculating-total-in-dimension/m-p/873894#M653780 2015-07-02T15:59:46Z Re: Calculating total in dimension https://community.qlik.com/t5/QlikView/Calculating-total-in-dimension/m-p/873895#M653781 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=If(Aggr(Sum(TOTAL &lt;PROD_DT, REL_CD&gt; VALUE), REL_CD) &gt; 10000000, REL_CD))</STRONG></SPAN></P></BODY></HTML> Thu, 02 Jul 2015 16:01:08 GMT https://community.qlik.com/t5/QlikView/Calculating-total-in-dimension/m-p/873895#M653781 sunny_talwar 2015-07-02T16:01:08Z