topic need code from Value>=Min and Value <=Max in QlikView

topic need code from Value>=Min and Value <=Max in QlikView https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2041252#M1222742 <DIV class="MinimumWidthContainer"> <DIV class="min-width-wrapper"> <DIV class="min-width"> <DIV class="lia-content"> <DIV class="lia-quilt lia-quilt-forum-topic-page lia-quilt-layout-two-column-main-side lia-top-quilt lia-forum-topic-page-gte-5"> <DIV class="lia-quilt-row lia-quilt-row-main"> <DIV class="lia-quilt-column lia-quilt-column-17 lia-quilt-column-left lia-quilt-column-main-content"> <DIV class="lia-quilt-column-alley lia-quilt-column-alley-left"> <DIV class="linear-message-list message-list"> <DIV id="lineardisplaymessageviewwrapper" class="lia-linear-display-message-view"> <DIV class="first-message lia-forum-linear-view-gte-v5"> <DIV id="messageview" class="lia-panel-message message-uid-2041199" data-lia-message-uid="2041199"> <DIV id="messageView2_1" class="lia-message-view-wrapper lia-js-data-messageUid-2041199 lia-component-forums-widget-message-view-two" data-lia-message-uid="2041199"> <DIV class="MessageView lia-message-view-forum-message lia-message-view-display lia-row-standard-read lia-thread-topic lia-message-authored-by-you"> <DIV class="lia-quilt lia-quilt-forum-message lia-quilt-layout-two-column-forum-message"> <DIV class="lia-quilt-row lia-quilt-row-main"> <DIV class="lia-quilt-column lia-quilt-column-21 lia-quilt-column-right lia-quilt-column-main-content"> <DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"> <DIV class="MessageInResponseTo lia-component-message-view-widget-in-response-to lia-component-in-response-to"> </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"> <DIV class="MessageInResponseTo lia-component-message-view-widget-in-response-to lia-component-in-response-to"> </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_3-1677133020763.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101177iE2EFD634113E79EF/image-size/medium?v=v2&px=400" role="button" title="Sxbbb_3-1677133020763.png" alt="Sxbbb_3-1677133020763.png" /></span> <P> </P> <P> </P> <P> </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>=Min and Value <=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_4-1677133020745.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101176iC0D74B1528B8AB21/image-size/medium?v=v2&px=400" role="button" title="Sxbbb_4-1677133020745.png" alt="Sxbbb_4-1677133020745.png" /></span> <P> </P> <P> </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> </P> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_5-1677133020813.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101175i4861EEFDD8A3E770/image-size/medium?v=v2&px=400" role="button" title="Sxbbb_5-1677133020813.png" alt="Sxbbb_5-1677133020813.png" /></span> <P> </P> <P> </P> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_6-1677133020815.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101178iB3C7D7B3221C892D/image-size/medium?v=v2&px=400" role="button" title="Sxbbb_6-1677133020815.png" alt="Sxbbb_6-1677133020815.png" /></span> <P> </P> <P> </P> <P><SPAN>used code of  'With in spec'.</SPAN></P> <P><SPAN>(Count(Aggr(if(Value>=Min and Value <= Max,Count(WorkOrder),0),Line,WorkOrder,SampleNo,Point))).</SPAN></P> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> Fri, 15 Nov 2024 21:48:02 GMT Sxbbb 2024-11-15T21:48:02Z need code from Value>=Min and Value <=Max https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2041252#M1222742 <DIV class="MinimumWidthContainer"> <DIV class="min-width-wrapper"> <DIV class="min-width"> <DIV class="lia-content"> <DIV class="lia-quilt lia-quilt-forum-topic-page lia-quilt-layout-two-column-main-side lia-top-quilt lia-forum-topic-page-gte-5"> <DIV class="lia-quilt-row lia-quilt-row-main"> <DIV class="lia-quilt-column lia-quilt-column-17 lia-quilt-column-left lia-quilt-column-main-content"> <DIV class="lia-quilt-column-alley lia-quilt-column-alley-left"> <DIV class="linear-message-list message-list"> <DIV id="lineardisplaymessageviewwrapper" class="lia-linear-display-message-view"> <DIV class="first-message lia-forum-linear-view-gte-v5"> <DIV id="messageview" class="lia-panel-message message-uid-2041199" data-lia-message-uid="2041199"> <DIV id="messageView2_1" class="lia-message-view-wrapper lia-js-data-messageUid-2041199 lia-component-forums-widget-message-view-two" data-lia-message-uid="2041199"> <DIV class="MessageView lia-message-view-forum-message lia-message-view-display lia-row-standard-read lia-thread-topic lia-message-authored-by-you"> <DIV class="lia-quilt lia-quilt-forum-message lia-quilt-layout-two-column-forum-message"> <DIV class="lia-quilt-row lia-quilt-row-main"> <DIV class="lia-quilt-column lia-quilt-column-21 lia-quilt-column-right lia-quilt-column-main-content"> <DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"> <DIV class="MessageInResponseTo lia-component-message-view-widget-in-response-to lia-component-in-response-to"> </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"> <DIV class="MessageInResponseTo lia-component-message-view-widget-in-response-to lia-component-in-response-to"> </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_3-1677133020763.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101177iE2EFD634113E79EF/image-size/medium?v=v2&px=400" role="button" title="Sxbbb_3-1677133020763.png" alt="Sxbbb_3-1677133020763.png" /></span> <P> </P> <P> </P> <P> </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>=Min and Value <=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_4-1677133020745.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101176iC0D74B1528B8AB21/image-size/medium?v=v2&px=400" role="button" title="Sxbbb_4-1677133020745.png" alt="Sxbbb_4-1677133020745.png" /></span> <P> </P> <P> </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> </P> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_5-1677133020813.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101175i4861EEFDD8A3E770/image-size/medium?v=v2&px=400" role="button" title="Sxbbb_5-1677133020813.png" alt="Sxbbb_5-1677133020813.png" /></span> <P> </P> <P> </P> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_6-1677133020815.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/101178iB3C7D7B3221C892D/image-size/medium?v=v2&px=400" role="button" title="Sxbbb_6-1677133020815.png" alt="Sxbbb_6-1677133020815.png" /></span> <P> </P> <P> </P> <P><SPAN>used code of  'With in spec'.</SPAN></P> <P><SPAN>(Count(Aggr(if(Value>=Min and Value <= Max,Count(WorkOrder),0),Line,WorkOrder,SampleNo,Point))).</SPAN></P> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> Fri, 15 Nov 2024 21:48:02 GMT https://community.qlik.com/t5/QlikView/need-code-from-Value-gt-Min-and-Value-lt-Max/m-p/2041252#M1222742 Sxbbb 2024-11-15T21:48:02Z