https://community.qlik.com/t5/App-Development/Give-some-idea-to-implement-this-logic-in-Qliksense/m-p/1602176#M63189 Hi, I already tried it. But its return "-" instead of "NA".Give some other options . Thanks Mon, 15 Jul 2019 08:12:05 GMT kaviyarasan 2019-07-15T08:12:05Z https://community.qlik.com/t5/App-Development/Give-some-idea-to-implement-this-logic-in-Qliksense/m-p/1601743#M63187 <TABLE><TBODY><TR><TD>TableName:</TD><TD>&nbsp;</TD></TR><TR><TD>A</TD><TD>B</TD></TR><TR><TD>NA</TD><TD>2</TD></TR><TR><TD>2</TD><TD>NA</TD></TR><TR><TD>3</TD><TD>4</TD></TR><TR><TD>NA</TD><TD>NA</TD></TR><TR><TD>43</TD><TD>21</TD></TR><TR><TD>5</TD><TD>3</TD></TR><TR><TD>Logic:</TD><TD>&nbsp;</TD></TR><TR><TD>if(or(A="NA",B="NA"),"NA",Sum(A)-sum(B))</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 20:28:07 GMT https://community.qlik.com/t5/App-Development/Give-some-idea-to-implement-this-logic-in-Qliksense/m-p/1601743#M63187 kaviyarasan 2024-11-16T20:28:07Z https://community.qlik.com/t5/App-Development/Give-some-idea-to-implement-this-logic-in-Qliksense/m-p/1601767#M63188 <P>Hi,&nbsp;</P><P>if you want to create a new field (let's say "C") then in script editor:</P><P>Load</P><P>A,</P><P>B,</P><P>if(A='NA' OR B='NA', 'NA', A-B) as C</P><P>From YOUR FOLDER;</P><P>Then create simple sum(C) in your UI.&nbsp;</P><P>&nbsp;</P> Mon, 15 Jul 2019 09:19:51 GMT https://community.qlik.com/t5/App-Development/Give-some-idea-to-implement-this-logic-in-Qliksense/m-p/1601767#M63188 mato32188 2019-07-15T09:19:51Z https://community.qlik.com/t5/App-Development/Give-some-idea-to-implement-this-logic-in-Qliksense/m-p/1602176#M63189 Hi, I already tried it. But its return "-" instead of "NA".Give some other options . Thanks Mon, 15 Jul 2019 08:12:05 GMT https://community.qlik.com/t5/App-Development/Give-some-idea-to-implement-this-logic-in-Qliksense/m-p/1602176#M63189 kaviyarasan 2019-07-15T08:12:05Z