https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2041221#M1222730 <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> Thu, 23 Feb 2023 04:09:49 GMT Sxbbb 2023-02-23T04:09:49Z https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2041199#M1222722 <DIV class="topic-subject-wrapper"> <DIV class="lia-message-subject lia-component-message-view-widget-subject"> <DIV class="MessageSubject"> <DIV class="lia-message-subject">need code from Value&gt;=Min and Value &lt;=Max</DIV> </DIV> </DIV> </DIV> <DIV class="MessageInResponseTo lia-component-message-view-widget-in-response-to lia-component-in-response-to">&nbsp;</DIV> <DIV id="bodyDisplay" class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"> <DIV class="lia-message-body-content"> <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> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_0-1677117489838.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101159i85BDBEE2C675552E/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_0-1677117489838.png" alt="Sxbbb_0-1677117489838.png" /></span> <P>&nbsp;</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> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_1-1677117489567.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101158i323B895B2EB952EB/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_1-1677117489567.png" alt="Sxbbb_1-1677117489567.png" /></span> <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">I can do it but then the Data is wrong.</SPAN></PRE> <P>&nbsp;</P> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_2-1677117489833.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101157i08701005D456A69C/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_2-1677117489833.png" alt="Sxbbb_2-1677117489833.png" /></span> <P>&nbsp;</P> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_3-1677117489854.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101160i9FAFCD51778BD2DA/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_3-1677117489854.png" alt="Sxbbb_3-1677117489854.png" /></span> <P>&nbsp;</P> <P><SPAN>used code of&nbsp; 'With in spec'.</SPAN></P> <P><SPAN>(Count(Aggr(if(Value&gt;=Min and Value &lt;= Max,Count(WorkOrder),0),Line,WorkOrder,SampleNo,Point))).</SPAN></P> </DIV> </DIV> Thu, 23 Feb 2023 01:59:33 GMT https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2041199#M1222722 Sxbbb 2023-02-23T01:59:33Z https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2041204#M1222724 <P>@<SPAN>&nbsp;</SPAN><A id="link_26" class="lia-link-navigation lia-page-link lia-user-name-link" href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628" target="_self" aria-label="View Profile of sunny_talwar" aria-describedby="userProfileCard-46628"><SPAN class="login-bold">Sunny_talwar</SPAN></A><SPAN>&nbsp;</SPAN></P> Thu, 23 Feb 2023 02:55:48 GMT https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2041204#M1222724 Sxbbb 2023-02-23T02:55:48Z https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2041221#M1222730 <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> Thu, 23 Feb 2023 04:09:49 GMT https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2041221#M1222730 Sxbbb 2023-02-23T04:09:49Z