topic Re: How to filter a count with a condition in Data Quality https://community.qlik.com/t5/Data-Quality/How-to-filter-a-count-with-a-condition/m-p/2536746#M4322 <P>Try this&nbsp;</P><P><STRONG>YourData:</STRONG><BR />Load * subfield(distnumber,, '-', 1) as dist_firstnumber;<BR />Load * Inline [<BR />itemcode, distnumber, onhandqty&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ........................<BR />];</P><P><STRONG>MinValue:</STRONG><BR />Load itemcode,<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Min(dist_firstnumber) as distinctValue<BR />resident Yourdata;</P><P><STRONG>chart expression</STRONG><BR />Count({&lt;dist_firstnumber=P(distinctValue)&gt;}itemcode)</P> Thu, 20 Nov 2025 13:38:07 GMT Nagaraju_KCS 2025-11-20T13:38:07Z How to filter a count with a condition https://community.qlik.com/t5/Data-Quality/How-to-filter-a-count-with-a-condition/m-p/2536558#M4319 <P>Hi i have this result :</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>itemcode</TD><TD>distnumber</TD><TD>onhandqty</TD></TR><TR><TD>1800000038</TD><TD>127-07</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>127-08</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>127-09</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>127-10</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>127-13</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>127-14</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>127-15</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>127-16</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>127-17</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>127-18</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>127-19</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>127-20</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-01</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-02</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-03</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-04</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-05</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-06</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-07</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-08</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-09</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-10</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-11</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-12</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-13</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-14</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-15</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-16</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-17</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-18</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-19</TD><TD>952.540000</TD></TR><TR><TD>1800000038</TD><TD>128-20</TD><TD>952.540000</TD></TR><TR><TD>1800000040</TD><TD>132-35</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>132-36</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>132-37</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>132-38</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>132-39</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>132-40</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-01</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-02</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-03</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-04</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-05</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-06</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-07</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-08</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-09</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-10</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-11</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-12</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-13</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-14</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-15</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-16</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-17</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-18</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-19</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-20</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-21</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-22</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-23</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-24</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-25</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-26</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-27</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-28</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-29</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-30</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-31</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-32</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-33</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-34</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-35</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-36</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-37</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-38</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-39</TD><TD>400.000000</TD></TR><TR><TD>1800000040</TD><TD>133-40</TD><TD>400.000000</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i&nbsp; want only a résult by item code with only the min of the three first number of distnumber and a count of this condition so the result is :</P><P>&nbsp;</P><P>into my table graphic i use&nbsp;</P><P>first colum =&nbsp; dimension&nbsp;</P><P>second :&nbsp; Min( SubField(distnumber, '-', 1) )&nbsp; (take only the min of the distnumber)</P><P>last colum&nbsp; :count(<BR />{&lt;<BR />distnumber = {"*$(=Aggr(Min(Left(distnumber,3))), U_CapacItemcode)*"}<BR />&gt;} distnumber<BR />)</P><P>&nbsp;</P><P>i have this result&nbsp; (no correct, the correct is&nbsp; 12&nbsp; for the O-71 (1800000038) , here is the total of the distnumber 127 and 128 of the 1800000038&nbsp; (O-71)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mahieuphilippe_0-1763539945143.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/185110iEBEBA29D2F194C0D/image-size/medium?v=v2&amp;px=400" role="button" title="mahieuphilippe_0-1763539945143.png" alt="mahieuphilippe_0-1763539945143.png" /></span></P><P>&nbsp;</P><P>this is the correct result&nbsp; &nbsp;how to have the good résult ?&nbsp; thanks</P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>1800000038</TD><TD>127</TD><TD>12</TD></TR><TR><TD>1800000040</TD><TD>132</TD><TD>6</TD></TR></TBODY></TABLE> Wed, 19 Nov 2025 08:35:19 GMT https://community.qlik.com/t5/Data-Quality/How-to-filter-a-count-with-a-condition/m-p/2536558#M4319 mahieuphilippe 2025-11-19T08:35:19Z Re: How to filter a count with a condition https://community.qlik.com/t5/Data-Quality/How-to-filter-a-count-with-a-condition/m-p/2536746#M4322 <P>Try this&nbsp;</P><P><STRONG>YourData:</STRONG><BR />Load * subfield(distnumber,, '-', 1) as dist_firstnumber;<BR />Load * Inline [<BR />itemcode, distnumber, onhandqty&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ........................<BR />];</P><P><STRONG>MinValue:</STRONG><BR />Load itemcode,<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Min(dist_firstnumber) as distinctValue<BR />resident Yourdata;</P><P><STRONG>chart expression</STRONG><BR />Count({&lt;dist_firstnumber=P(distinctValue)&gt;}itemcode)</P> Thu, 20 Nov 2025 13:38:07 GMT https://community.qlik.com/t5/Data-Quality/How-to-filter-a-count-with-a-condition/m-p/2536746#M4322 Nagaraju_KCS 2025-11-20T13:38:07Z Re: How to filter a count with a condition https://community.qlik.com/t5/Data-Quality/How-to-filter-a-count-with-a-condition/m-p/2537405#M4323 <P>thanks you !!!!</P> Thu, 27 Nov 2025 10:53:58 GMT https://community.qlik.com/t5/Data-Quality/How-to-filter-a-count-with-a-condition/m-p/2537405#M4323 mahieuphilippe 2025-11-27T10:53:58Z