Is it possible to have a construction like below in qlikview?
I always get a syntax error. Can someone help me with this issue?
IF(ChargeCde<>'""',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,
