topic Re: How to ignore a dimension while using SUM in App Development https://community.qlik.com/t5/App-Development/How-to-ignore-a-dimension-while-using-SUM/m-p/1646361#M48196 <P>Hello,</P><P>Thanks for the fast reply.</P><P>I have tried using the formula you posted like this;</P><P>Sum({&lt;[TableZ.custpartnumber]=&gt;}[TableX.quantity]) but no success <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span>&nbsp;</P> Wed, 13 Nov 2019 12:47:16 GMT VolkanKu 2019-11-13T12:47:16Z How to ignore a dimension while using SUM https://community.qlik.com/t5/App-Development/How-to-ignore-a-dimension-while-using-SUM/m-p/1646340#M48194 <P>Hello,</P><P>I am trying to make a report but i got stuck at getting a sum while ignoring one of the dimensions at the chart.</P><P>What i am trying to report is the top 5 materials for each period(Year, Month or Week if can use alternative or just Month if i cant) Rework Quantity of material in period / Total Stock Quantity for the period.</P><P>There are also a lot of other filters in the app from various tables that are joined by Material column. Is there any way to omit a dimension while using SUM function or can i get the result by using another function?</P><P>The main data i am using is like these 2 tables. Also the end result i need looks like the picture at the end, with ratios replacing material codes.&nbsp;&nbsp;</P><TABLE><TBODY><TR><TD>TABLEX</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>TABLEY</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>TableZ</TD><TD>&nbsp;</TD></TR><TR><TD>Material</TD><TD>Date</TD><TD>Stock Quantity</TD><TD>&nbsp;</TD><TD>Material</TD><TD>Date</TD><TD>Rework Quantity</TD><TD>&nbsp;</TD><TD>Material</TD><TD>Custpartnumber</TD></TR><TR><TD>A</TD><TD>01.10.2019</TD><TD>36865</TD><TD>&nbsp;</TD><TD>A</TD><TD>01.10.2019</TD><TD>127</TD><TD>&nbsp;</TD><TD>A</TD><TD>AAAA</TD></TR><TR><TD>C</TD><TD>01.10.2019</TD><TD>141</TD><TD>&nbsp;</TD><TD>C</TD><TD>01.10.2019</TD><TD>19</TD><TD>&nbsp;</TD><TD>B</TD><TD>BBBB</TD></TR><TR><TD>A</TD><TD>01.09.2019</TD><TD>103</TD><TD>&nbsp;</TD><TD>A</TD><TD>01.09.2019</TD><TD>106</TD><TD>&nbsp;</TD><TD>C</TD><TD>CCCC</TD></TR><TR><TD>B</TD><TD>01.09.2019</TD><TD>390</TD><TD>&nbsp;</TD><TD>B</TD><TD>01.09.2019</TD><TD>27</TD><TD>&nbsp;</TD><TD>D</TD><TD>DDDD</TD></TR><TR><TD>C</TD><TD>01.09.2019</TD><TD>133</TD><TD>&nbsp;</TD><TD>C</TD><TD>01.09.2019</TD><TD>10</TD><TD>&nbsp;</TD><TD>E</TD><TD>EEEE</TD></TR><TR><TD>A</TD><TD>01.08.2019</TD><TD>56</TD><TD>&nbsp;</TD><TD>A</TD><TD>01.08.2019</TD><TD>6</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>B</TD><TD>01.08.2019</TD><TD>552</TD><TD>&nbsp;</TD><TD>B</TD><TD>01.08.2019</TD><TD>256</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>C</TD><TD>01.08.2019</TD><TD>28</TD><TD>&nbsp;</TD><TD>C</TD><TD>01.08.2019</TD><TD>47</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>A</TD><TD>01.07.2019</TD><TD>148</TD><TD>&nbsp;</TD><TD>A</TD><TD>01.07.2019</TD><TD>6</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>B</TD><TD>01.07.2019</TD><TD>16</TD><TD>&nbsp;</TD><TD>B</TD><TD>01.07.2019</TD><TD>336</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>A</TD><TD>01.07.2019</TD><TD>362</TD><TD>&nbsp;</TD><TD>A</TD><TD>01.07.2019</TD><TD>32</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>A</TD><TD>01.06.2019</TD><TD>90</TD><TD>&nbsp;</TD><TD>A</TD><TD>01.06.2019</TD><TD>1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>B</TD><TD>01.06.2019</TD><TD>188</TD><TD>&nbsp;</TD><TD>B</TD><TD>01.06.2019</TD><TD>209</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>C</TD><TD>01.06.2019</TD><TD>285</TD><TD>&nbsp;</TD><TD>C</TD><TD>01.06.2019</TD><TD>11</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>D</TD><TD>01.06.2019</TD><TD>2865</TD><TD>&nbsp;</TD><TD>D</TD><TD>01.06.2019</TD><TD>81</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>E</TD><TD>01.06.2019</TD><TD>448</TD><TD>&nbsp;</TD><TD>E</TD><TD>01.06.2019</TD><TD>81</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The results i am trying to get are like these below, month year as dimension and year as alternative dimension.</P><TABLE><TBODY><TR><TD>Month Year</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Year</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Material (1)</TD><TD>Date&nbsp;(2)</TD><TD>Total Stock Quantity for the period&nbsp;(3)</TD><TD>Rework Quantity of material in period&nbsp;(4)</TD><TD><P>Rework Ratio</P><P>(4/3)</P></TD><TD>&nbsp;</TD><TD>Material (1)</TD><TD>Date&nbsp;(2)</TD><TD>Total Stock Quantity for the period&nbsp;(3)</TD><TD>Rework Quantity of material in period&nbsp;(4)</TD><TD><P>Rework Ratio</P><P>(4/3)</P></TD></TR><TR><TD>A</TD><TD>01.10.2019</TD><TD>37006</TD><TD>127</TD><TD>0,34%</TD><TD>&nbsp;</TD><TD>A</TD><TD>2019</TD><TD>42670</TD><TD>278</TD><TD>0,65%</TD></TR><TR><TD>C</TD><TD>01.10.2019</TD><TD>37006</TD><TD>19</TD><TD>0,05%</TD><TD>&nbsp;</TD><TD>C</TD><TD>2019</TD><TD>42670</TD><TD>87</TD><TD>0,20%</TD></TR><TR><TD>A</TD><TD>01.09.2019</TD><TD>626</TD><TD>106</TD><TD>16,93%</TD><TD>&nbsp;</TD><TD>A</TD><TD>2019</TD><TD>42670</TD><TD>278</TD><TD>0,65%</TD></TR><TR><TD>B</TD><TD>01.09.2019</TD><TD>626</TD><TD>27</TD><TD>4,31%</TD><TD>&nbsp;</TD><TD>B</TD><TD>2019</TD><TD>42670</TD><TD>828</TD><TD>1,94%</TD></TR><TR><TD>C</TD><TD>01.09.2019</TD><TD>626</TD><TD>10</TD><TD>1,60%</TD><TD>&nbsp;</TD><TD>C</TD><TD>2019</TD><TD>42670</TD><TD>87</TD><TD>0,20%</TD></TR><TR><TD>A</TD><TD>01.08.2019</TD><TD>636</TD><TD>6</TD><TD>0,94%</TD><TD>&nbsp;</TD><TD>A</TD><TD>2019</TD><TD>42670</TD><TD>278</TD><TD>0,65%</TD></TR><TR><TD>B</TD><TD>01.08.2019</TD><TD>636</TD><TD>256</TD><TD>40,25%</TD><TD>&nbsp;</TD><TD>B</TD><TD>2019</TD><TD>42670</TD><TD>828</TD><TD>1,94%</TD></TR><TR><TD>C</TD><TD>01.08.2019</TD><TD>636</TD><TD>47</TD><TD>7,39%</TD><TD>&nbsp;</TD><TD>C</TD><TD>2019</TD><TD>42670</TD><TD>87</TD><TD>0,20%</TD></TR><TR><TD>A</TD><TD>01.07.2019</TD><TD>526</TD><TD>38</TD><TD>7,22%</TD><TD>&nbsp;</TD><TD>A</TD><TD>2019</TD><TD>42670</TD><TD>278</TD><TD>0,65%</TD></TR><TR><TD>B</TD><TD>01.07.2019</TD><TD>526</TD><TD>336</TD><TD>63,88%</TD><TD>&nbsp;</TD><TD>B</TD><TD>2019</TD><TD>42670</TD><TD>828</TD><TD>1,94%</TD></TR><TR><TD>A</TD><TD>01.07.2019</TD><TD>526</TD><TD>38</TD><TD>7,22%</TD><TD>&nbsp;</TD><TD>A</TD><TD>2019</TD><TD>42670</TD><TD>278</TD><TD>0,65%</TD></TR><TR><TD>A</TD><TD>01.06.2019</TD><TD>3876</TD><TD>1</TD><TD>0,03%</TD><TD>&nbsp;</TD><TD>A</TD><TD>2019</TD><TD>42670</TD><TD>278</TD><TD>0,65%</TD></TR><TR><TD>B</TD><TD>01.06.2019</TD><TD>3876</TD><TD>209</TD><TD>5,39%</TD><TD>&nbsp;</TD><TD>B</TD><TD>2019</TD><TD>42670</TD><TD>828</TD><TD>1,94%</TD></TR><TR><TD>C</TD><TD>01.06.2019</TD><TD>3876</TD><TD>11</TD><TD>0,28%</TD><TD>&nbsp;</TD><TD>C</TD><TD>2019</TD><TD>42670</TD><TD>87</TD><TD>0,20%</TD></TR><TR><TD>D</TD><TD>01.06.2019</TD><TD>3876</TD><TD>81</TD><TD>2,09%</TD><TD>&nbsp;</TD><TD>D</TD><TD>2019</TD><TD>42670</TD><TD>81</TD><TD>0,19%</TD></TR><TR><TD>E</TD><TD>01.06.2019</TD><TD>3876</TD><TD>81</TD><TD>2,09%</TD><TD>&nbsp;</TD><TD>E</TD><TD>2019</TD><TD>42670</TD><TD>81</TD><TD>0,19%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Result.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/23556i376CF1E66A40EE1B/image-size/large?v=v2&amp;px=999" role="button" title="Result.jpg" alt="Result.jpg" /></span></P> Thu, 14 Nov 2019 05:25:01 GMT https://community.qlik.com/t5/App-Development/How-to-ignore-a-dimension-while-using-SUM/m-p/1646340#M48194 VolkanKu 2019-11-14T05:25:01Z Re: How to ignore a dimension while using SUM https://community.qlik.com/t5/App-Development/How-to-ignore-a-dimension-while-using-SUM/m-p/1646354#M48195 <P>hi</P><P>try like this</P><P>Sum({&lt;[Dimension]=&gt;}Value)</P><P>this will nullify the filters applied on those dimensions</P><P>Hope this helps</P><P>Thanks&nbsp;</P> Wed, 13 Nov 2019 12:35:27 GMT https://community.qlik.com/t5/App-Development/How-to-ignore-a-dimension-while-using-SUM/m-p/1646354#M48195 Kashyap_R 2019-11-13T12:35:27Z Re: How to ignore a dimension while using SUM https://community.qlik.com/t5/App-Development/How-to-ignore-a-dimension-while-using-SUM/m-p/1646361#M48196 <P>Hello,</P><P>Thanks for the fast reply.</P><P>I have tried using the formula you posted like this;</P><P>Sum({&lt;[TableZ.custpartnumber]=&gt;}[TableX.quantity]) but no success <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span>&nbsp;</P> Wed, 13 Nov 2019 12:47:16 GMT https://community.qlik.com/t5/App-Development/How-to-ignore-a-dimension-while-using-SUM/m-p/1646361#M48196 VolkanKu 2019-11-13T12:47:16Z Re: How to ignore a dimension while using SUM https://community.qlik.com/t5/App-Development/How-to-ignore-a-dimension-while-using-SUM/m-p/1646491#M48212 <P>Hi Volkan,</P><P>Can you give a sketch of the outcome? This would make it a lot easier.</P><P>Jordy</P><P>Climber</P> Wed, 13 Nov 2019 15:09:34 GMT https://community.qlik.com/t5/App-Development/How-to-ignore-a-dimension-while-using-SUM/m-p/1646491#M48212 JordyWegman 2019-11-13T15:09:34Z Re: How to ignore a dimension while using SUM https://community.qlik.com/t5/App-Development/How-to-ignore-a-dimension-while-using-SUM/m-p/1646750#M48225 <P>Hello,</P><P>&nbsp;</P><P>I have edited the post to include the desired results <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P> Thu, 14 Nov 2019 05:26:21 GMT https://community.qlik.com/t5/App-Development/How-to-ignore-a-dimension-while-using-SUM/m-p/1646750#M48225 VolkanKu 2019-11-14T05:26:21Z