https://community.qlik.com/t5/QlikView/SCRIPT/m-p/1744611#M719979 <P>Dear All</P><P>&nbsp;</P><P>I have two QVD'S</P><P>1.SVAT1.QVD</P><P>2.SVAT.QVD</P><P>in that qvd include AMT1 in SVAT1.QVD and AMT2 in SVAT.QVD. I want to calculate following conditioned in script.Please help me</P><P>&nbsp;</P><P>IF((AMT1+AMT)=&gt;0,N,Y) AS SVAT</P><P>&nbsp;</P><P>&nbsp;</P><P>THIS FORMULA NOT WORKING. WHAT AMT1 and AMT include differant&nbsp; QVD'S .How to fix it please help</P><P>&nbsp;</P><P>sagara</P> Fri, 15 Nov 2024 23:57:49 GMT sagaraperera 2024-11-15T23:57:49Z https://community.qlik.com/t5/QlikView/SCRIPT/m-p/1744611#M719979 <P>Dear All</P><P>&nbsp;</P><P>I have two QVD'S</P><P>1.SVAT1.QVD</P><P>2.SVAT.QVD</P><P>in that qvd include AMT1 in SVAT1.QVD and AMT2 in SVAT.QVD. I want to calculate following conditioned in script.Please help me</P><P>&nbsp;</P><P>IF((AMT1+AMT)=&gt;0,N,Y) AS SVAT</P><P>&nbsp;</P><P>&nbsp;</P><P>THIS FORMULA NOT WORKING. WHAT AMT1 and AMT include differant&nbsp; QVD'S .How to fix it please help</P><P>&nbsp;</P><P>sagara</P> Fri, 15 Nov 2024 23:57:49 GMT https://community.qlik.com/t5/QlikView/SCRIPT/m-p/1744611#M719979 sagaraperera 2024-11-15T23:57:49Z https://community.qlik.com/t5/QlikView/SCRIPT/m-p/1744635#M719980 <P>combine the 2 QVDS in ONE table (depends on how your&nbsp; data is build)</P><P>when you'll have the 2 qvds data in ONE load; then you could execute your condition</P> Thu, 17 Sep 2020 08:37:55 GMT https://community.qlik.com/t5/QlikView/SCRIPT/m-p/1744635#M719980 OmarBenSalem 2020-09-17T08:37:55Z