https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2040769#M1222704 <P><SPAN>(Count(Aggr(if(Value&gt;=Min and Value &lt;= Max,Count(WorkOrder),0),Line,WorkOrder,SampleNo,Point))).</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_0-1677053488591.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101098i440A2AEA0FF11003/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_0-1677053488591.png" alt="Sxbbb_0-1677053488591.png" /></span></P> <P><SPAN>still not correct</SPAN></P> Wed, 22 Feb 2023 08:11:48 GMT Sxbbb 2023-02-22T08:11:48Z https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2040756#M1222702 <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Translation"><SPAN class="Y2IQFc">I want to create a table like this</SPAN></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_2-1677051448462.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101089iFE2239255B93CEAF/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_2-1677051448462.png" alt="Sxbbb_2-1677051448462.png" /></span></P> <P>&nbsp;</P> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Translation"><SPAN class="Y2IQFc">Where 'With in spec' comes from Value&gt;=Min and Value &lt;=Max.</SPAN></PRE> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Translation"><SPAN class="Y2IQFc">Example 1 work order</SPAN></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_3-1677051623559.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101090i259515C0D174A217/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_3-1677051623559.png" alt="Sxbbb_3-1677051623559.png" /></span></P> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Translation"><SPAN class="Y2IQFc">I can do it but then the Data is wrong.</SPAN></PRE> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_4-1677051857759.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101091i773CA4DDAED1C37D/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_4-1677051857759.png" alt="Sxbbb_4-1677051857759.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_5-1677051892167.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101092iB17174B6A5E17E40/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_5-1677051892167.png" alt="Sxbbb_5-1677051892167.png" /></span></P> <P><SPAN>used code of&nbsp; 'With in spec'.</SPAN></P> <P><SPAN>(Count(Aggr(if(Value&gt;=Min and Value &lt;= Max,1,0),Line,WorkOrder,SampleNo,Point))).</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 22 Feb 2023 07:54:21 GMT https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2040756#M1222702 Sxbbb 2023-02-22T07:54:21Z https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2040769#M1222704 <P><SPAN>(Count(Aggr(if(Value&gt;=Min and Value &lt;= Max,Count(WorkOrder),0),Line,WorkOrder,SampleNo,Point))).</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_0-1677053488591.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101098i440A2AEA0FF11003/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_0-1677053488591.png" alt="Sxbbb_0-1677053488591.png" /></span></P> <P><SPAN>still not correct</SPAN></P> Wed, 22 Feb 2023 08:11:48 GMT https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2040769#M1222704 Sxbbb 2023-02-22T08:11:48Z https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2041219#M1222729 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/58578">@edwin</a>&nbsp;&nbsp;</P> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Translation"><SPAN class="Y2IQFc">can you help me</SPAN></PRE> <P>&nbsp;</P> Thu, 23 Feb 2023 03:57:20 GMT https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2041219#M1222729 Sxbbb 2023-02-23T03:57:20Z