https://community.qlik.com/t5/App-Development/Load-fails-when-using-Where-Exists-if-field-commented-out-on/m-p/1537816#M62702 <P>We upraded to November 2018 and then installed Patch2 last night and this morning we are getting reloads failing.</P><P>Seems that if we use use WHERE EXISTS(AcctNum) but that <SPAN>AcctNum&nbsp;</SPAN>is commented out in the Load Script above and it gives us a&nbsp;General Script Error in statement handling.</P><P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Where Exists" style="width: 475px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4928iFD2A120E7F2AE7A9/image-size/large?v=v2&amp;px=999" role="button" title="WhereExists.PNG" alt="Where Exists" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Where Exists</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Error" style="width: 706px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4927i69EE2E68E17A967F/image-size/large?v=v2&amp;px=999" role="button" title="GeneralScriptError.PNG" alt="Error" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Error</span></span></P> Sat, 16 Nov 2024 06:42:28 GMT patbuchanan 2024-11-16T06:42:28Z https://community.qlik.com/t5/App-Development/Load-fails-when-using-Where-Exists-if-field-commented-out-on/m-p/1537816#M62702 <P>We upraded to November 2018 and then installed Patch2 last night and this morning we are getting reloads failing.</P><P>Seems that if we use use WHERE EXISTS(AcctNum) but that <SPAN>AcctNum&nbsp;</SPAN>is commented out in the Load Script above and it gives us a&nbsp;General Script Error in statement handling.</P><P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Where Exists" style="width: 475px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4928iFD2A120E7F2AE7A9/image-size/large?v=v2&amp;px=999" role="button" title="WhereExists.PNG" alt="Where Exists" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Where Exists</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Error" style="width: 706px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4927i69EE2E68E17A967F/image-size/large?v=v2&amp;px=999" role="button" title="GeneralScriptError.PNG" alt="Error" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Error</span></span></P> Sat, 16 Nov 2024 06:42:28 GMT https://community.qlik.com/t5/App-Development/Load-fails-when-using-Where-Exists-if-field-commented-out-on/m-p/1537816#M62702 patbuchanan 2024-11-16T06:42:28Z https://community.qlik.com/t5/App-Development/Load-fails-when-using-Where-Exists-if-field-commented-out-on/m-p/1537966#M62703 <P>There was a change to the functionality within the last release. Until now it's not clear why it was changed and if it might be reversed again. Therefore I think you will need to adjust your logics. More background to the topic could you find here:</P><P><A href="https://community.qlik.com/t5/Qlik-Sense-App-Development/Where-exists-function-giving-error-in-Qlik-Sense-Nov-2018/td-p/1517286" target="_blank">Where-exists-function-giving-error-in-Qlik-Sense-Nov-2018</A></P><P>- Marcus</P> Thu, 31 Jan 2019 15:38:48 GMT https://community.qlik.com/t5/App-Development/Load-fails-when-using-Where-Exists-if-field-commented-out-on/m-p/1537966#M62703 marcus_sommer 2019-01-31T15:38:48Z