topic exists in qlikview load in QlikView https://community.qlik.com/t5/QlikView/exists-in-qlikview-load/m-p/188837#M51943 <HTML><HEAD></HEAD><BODY><P>Is it possible to have a construction like below in qlikview?</P><P>I always get a syntax error. Can someone help me with this issue?</P><P style="font-weight: bold"></P><P style="font-weight: bold">IF(ChargeCde&lt;&gt;'""',if(not ISNULL(LOAD * RESIDENT ParmSpVL where Invoice_1.ChargeCde=ParmSpVl.ParmCde and ParmFld='CHARGECDE' and labelCde='CumTrnOv' AND SpecValL='yes'),OrdAmtDLc,0),OrdAmtDLc)as test,</P><P style="font-weight: bold"></P><BR /><BR /> <P></P></BODY></HTML> Wed, 16 Dec 2009 15:08:02 GMT 2009-12-16T15:08:02Z exists in qlikview load https://community.qlik.com/t5/QlikView/exists-in-qlikview-load/m-p/188837#M51943 <HTML><HEAD></HEAD><BODY><P>Is it possible to have a construction like below in qlikview?</P><P>I always get a syntax error. Can someone help me with this issue?</P><P style="font-weight: bold"></P><P style="font-weight: bold">IF(ChargeCde&lt;&gt;'""',if(not ISNULL(LOAD * RESIDENT ParmSpVL where Invoice_1.ChargeCde=ParmSpVl.ParmCde and ParmFld='CHARGECDE' and labelCde='CumTrnOv' AND SpecValL='yes'),OrdAmtDLc,0),OrdAmtDLc)as test,</P><P style="font-weight: bold"></P><BR /><BR /> <P></P></BODY></HTML> Wed, 16 Dec 2009 15:08:02 GMT https://community.qlik.com/t5/QlikView/exists-in-qlikview-load/m-p/188837#M51943 2009-12-16T15:08:02Z