https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427607#M96271 <P>Can you please share a small data sample as well as how and with what dimensions you need to calculate the values?</P> Wed, 06 Mar 2024 09:12:58 GMT LRuCelver 2024-03-06T09:12:58Z https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2423970#M95946 <P>I want to check whether Machine Runlot information exists in Machine FA or not.&nbsp;</P> <P>If Machine Runlot does not exist in Machine FA, count Base WOrk Output.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_0-1709026082151.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/160715i9758C1DFF3611F9F/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_0-1709026082151.png" alt="Sxbbb_0-1709026082151.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_1-1709026194830.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/160716i5C3BECFAB32F9110/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_1-1709026194830.png" alt="Sxbbb_1-1709026194830.png" /></span></P> <P>&nbsp;</P> Fri, 15 Nov 2024 21:03:05 GMT https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2423970#M95946 Sxbbb 2024-11-15T21:03:05Z https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2423986#M95949 <P>You can use&nbsp;<A href="https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/StringFunctions/SubStringCount.htm" target="_blank">SubStringCount</A>&nbsp;to check whether a substring exists in a string.</P> Tue, 27 Feb 2024 09:53:08 GMT https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2423986#M95949 LRuCelver 2024-02-27T09:53:08Z https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427470#M96260 <P>I tried it and it's correct.&nbsp;But I want to count Base Work Output which is 0 and QTY FA = 'N/A '.&nbsp;</P> <P><FONT color="#FF0000">I want the sum</FONT>&nbsp;count Base Work Output</P> <P>I tried but it's not correct.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_1-1709696453556.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161380i5031FD471F657150/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_1-1709696453556.png" alt="Sxbbb_1-1709696453556.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_2-1709696584500.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161381i7C56302D297CB609/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_2-1709696584500.png" alt="Sxbbb_2-1709696584500.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 06 Mar 2024 03:43:13 GMT https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427470#M96260 Sxbbb 2024-03-06T03:43:13Z https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427528#M96262 <P>I'm assuming the column "Base WOrk Output" is the field "WorkOrder_BaseOutput".</P> <P>Since it is a dimension in the table, the count distinct will always return 1. If you want to count the number of times the combination of dimensions appears in you data, drop the distinct from your expression. You might also consider adding the else-case to the if statement if it is wanted.</P> <P>If my assumption is incorrect, please provide some sample data and a mockup of what the result should be, given the sample data.</P> Wed, 06 Mar 2024 06:59:35 GMT https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427528#M96262 LRuCelver 2024-03-06T06:59:35Z https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427539#M96266 <P>Yes, I would like to know how many Base Work Outputs that Machine Runlot does not have in Machine FA.</P> <P>What do I have to do?</P> Wed, 06 Mar 2024 07:31:40 GMT https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427539#M96266 Sxbbb 2024-03-06T07:31:40Z https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427565#M96267 <P>Removing "distinct" from the count might be enough, depending on your data.</P> Wed, 06 Mar 2024 08:17:24 GMT https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427565#M96267 LRuCelver 2024-03-06T08:17:24Z https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427599#M96270 <P>Invalid value I need to put the values ​​in a summary table.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_0-1709715757087.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161404i1DE0052FB554D771/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_0-1709715757087.png" alt="Sxbbb_0-1709715757087.png" /></span></P> <P>&nbsp;</P> Wed, 06 Mar 2024 09:02:44 GMT https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427599#M96270 Sxbbb 2024-03-06T09:02:44Z https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427607#M96271 <P>Can you please share a small data sample as well as how and with what dimensions you need to calculate the values?</P> Wed, 06 Mar 2024 09:12:58 GMT https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427607#M96271 LRuCelver 2024-03-06T09:12:58Z https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427629#M96273 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_0-1709717530415.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161411iB8373989D5E1C33B/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_0-1709717530415.png" alt="Sxbbb_0-1709717530415.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_1-1709717558458.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161412i7297AEBDC1C5E81F/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_1-1709717558458.png" alt="Sxbbb_1-1709717558458.png" /></span></P> <P>&nbsp;</P> <P>Machine FA :</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_2-1709717617450.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161413iA6DD295F05ADEF0D/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_2-1709717617450.png" alt="Sxbbb_2-1709717617450.png" /></span></P> <P>&nbsp;</P> <P>Machine Runlot :</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_3-1709717656465.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161414iC97D7F31458A3108/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_3-1709717656465.png" alt="Sxbbb_3-1709717656465.png" /></span></P> <P>&nbsp;</P> Wed, 06 Mar 2024 09:34:52 GMT https://community.qlik.com/t5/App-Development/check-whether-Machine-Runlot-information-exists-in-Machine-FA/m-p/2427629#M96273 Sxbbb 2024-03-06T09:34:52Z