topic Re: Sum Calculation in QlikView https://community.qlik.com/t5/QlikView/Sum-Calculation/m-p/411730#M558519 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>=[Total Complaint] /</P><P></P><P>sum( TOTAL&lt;MainArticle&gt; aggr(if([Item number]&lt;&gt;MainArticle ,' ',Sum ( InvoiceQty)),[Item number])) </P></BODY></HTML> Mon, 27 May 2013 18:55:42 GMT swuehl 2013-05-27T18:55:42Z Sum Calculation https://community.qlik.com/t5/QlikView/Sum-Calculation/m-p/411729#M558518 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>i would like to show the&nbsp; percentage calculation of the article No per MainArticle without Selecting the dimension Main Article as in the picture below the first.</P><P></P><P></P><P>is it poosible to calculate on partial total?</P><P><IMG __jive_id="41732" class="jive-image-thumbnail jive-image" onclick="" alt="Problem.jpg" src="https://community.qlik.com/legacyfs/online/41732_Problem.jpg" width="450" /></P><P>attached is the qwv.</P></BODY></HTML> Mon, 27 May 2013 18:11:54 GMT https://community.qlik.com/t5/QlikView/Sum-Calculation/m-p/411729#M558518 2013-05-27T18:11:54Z Re: Sum Calculation https://community.qlik.com/t5/QlikView/Sum-Calculation/m-p/411730#M558519 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>=[Total Complaint] /</P><P></P><P>sum( TOTAL&lt;MainArticle&gt; aggr(if([Item number]&lt;&gt;MainArticle ,' ',Sum ( InvoiceQty)),[Item number])) </P></BODY></HTML> Mon, 27 May 2013 18:55:42 GMT https://community.qlik.com/t5/QlikView/Sum-Calculation/m-p/411730#M558519 swuehl 2013-05-27T18:55:42Z