topic Re: Set Expression in QlikView https://community.qlik.com/t5/QlikView/Set-Expression/m-p/637313#M233709 <HTML><HEAD></HEAD><BODY><P>Try :</P><P>sum (if(Len( Trim( NP_REFUND_DATE ) ) &gt; 0&nbsp; or Len( Trim( REFUND_DATE ) ) &gt; 0,TOTAL))</P></BODY></HTML> Sun, 18 May 2014 16:08:18 GMT antoniotiman 2014-05-18T16:08:18Z Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/637312#M233708 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>sum (if(Len( Trim( NP_REFUND_DATE ) ) &gt; 0 ,TOTAL))</P><P></P><P>my above set expression is working fine. But my following one is not working</P><P></P><P>sum (if(Len( Trim( NP_REFUND_DATE ) ) &gt; 0&nbsp; or if(Len( Trim( REFUND_DATE ) ) &gt; 0,TOTAL)))</P><P></P><P>Pls help me to correct my above expression</P></BODY></HTML> Sun, 18 May 2014 15:36:01 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/637312#M233708 upaliwije 2014-05-18T15:36:01Z Re: Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/637313#M233709 <HTML><HEAD></HEAD><BODY><P>Try :</P><P>sum (if(Len( Trim( NP_REFUND_DATE ) ) &gt; 0&nbsp; or Len( Trim( REFUND_DATE ) ) &gt; 0,TOTAL))</P></BODY></HTML> Sun, 18 May 2014 16:08:18 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/637313#M233709 antoniotiman 2014-05-18T16:08:18Z Re: Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/637314#M233710 <HTML><HEAD></HEAD><BODY><P>Thanks a lot</P></BODY></HTML> Sun, 18 May 2014 16:11:28 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/637314#M233710 upaliwije 2014-05-18T16:11:28Z Re: Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/637315#M233711 <HTML><HEAD></HEAD><BODY><P>Hi, try this</P><P></P><P>=if(len(trim(NP_REFUND_DATE))&gt;0 or len(trim(REFUND_DATE))&gt;0, sum(TOTAL))</P><P></P><P>Fernando</P></BODY></HTML> Sun, 18 May 2014 16:18:10 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/637315#M233711 fkeuroglian 2014-05-18T16:18:10Z