topic Nested IF statements - HELP!!! in QlikView https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215212#M68692 <HTML><HEAD></HEAD><BODY><P>Hi everyone!</P><P>I inherited a code piece that contains nested IF statements. Issue: somehow it stopped working...</P><P>The code is:</P><P></P><P></P><P></P><P></P><P></P><P>IF</P><P></P><P></P>( LEN(TRIM(sourceBL)) &lt;&gt; 0 <B>AND</B> IF( LEN(TRIM(sourcePortfolio)) &lt;&gt; 0, 'ActiveBDS' <P>,</P><P>IF</P><P></P><P></P>( LEN(TRIM(sourceBL)) = 0 <B>AND</B> IF( LEN(TRIM(sourcePortfolio)) &lt;&gt; 0, 'NotActiveBDS' <P>,</P><P>IF</P><P></P><P></P>( LEN(TRIM(sourceBL)) = 0 <B>AND</B> IF( LEN(TRIM(sourcePortfolio)) = 0, 'Error' <P>,</P><P>IF</P><P></P><P></P>( LEN(TRIM(sourceBL)) &lt;&gt; 0 <B>AND</B> IF( LEN(TRIM(sourcePortfolio)) = 0, 'NotAssignedinPortfolio', 'XXXXX'))))))) <B>as</B> <P>Status</P><P></P><P>I just cannot see the syntax issue by myself...</P><P>Please help!</P><BR /><BR /> <BR /><BR /></BODY></HTML> Mon, 14 Feb 2011 14:30:33 GMT 2011-02-14T14:30:33Z Nested IF statements - HELP!!! https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215212#M68692 <HTML><HEAD></HEAD><BODY><P>Hi everyone!</P><P>I inherited a code piece that contains nested IF statements. Issue: somehow it stopped working...</P><P>The code is:</P><P></P><P></P><P></P><P></P><P></P><P>IF</P><P></P><P></P>( LEN(TRIM(sourceBL)) &lt;&gt; 0 <B>AND</B> IF( LEN(TRIM(sourcePortfolio)) &lt;&gt; 0, 'ActiveBDS' <P>,</P><P>IF</P><P></P><P></P>( LEN(TRIM(sourceBL)) = 0 <B>AND</B> IF( LEN(TRIM(sourcePortfolio)) &lt;&gt; 0, 'NotActiveBDS' <P>,</P><P>IF</P><P></P><P></P>( LEN(TRIM(sourceBL)) = 0 <B>AND</B> IF( LEN(TRIM(sourcePortfolio)) = 0, 'Error' <P>,</P><P>IF</P><P></P><P></P>( LEN(TRIM(sourceBL)) &lt;&gt; 0 <B>AND</B> IF( LEN(TRIM(sourcePortfolio)) = 0, 'NotAssignedinPortfolio', 'XXXXX'))))))) <B>as</B> <P>Status</P><P></P><P>I just cannot see the syntax issue by myself...</P><P>Please help!</P><BR /><BR /> <BR /><BR /></BODY></HTML> Mon, 14 Feb 2011 14:30:33 GMT https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215212#M68692 2011-02-14T14:30:33Z Nested IF statements - HELP!!! https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215213#M68693 <HTML><HEAD></HEAD><BODY><P>Here is a tool that might be usefull:</P><P><A href="http://www.qlikblog.at/tools/Nested-If-Generator.html" target="_blank">http://www.qlikblog.at/tools/Nested-If-Generator.html</A></P><P>Good luck.</P></BODY></HTML> Mon, 14 Feb 2011 14:35:05 GMT https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215213#M68693 Anonymous 2011-02-14T14:35:05Z Nested IF statements - HELP!!! https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215214#M68694 <HTML><HEAD></HEAD><BODY><P>Error message:</P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/1537.error.JPG"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/1537.error.JPG" /></A></P></BODY></HTML> Mon, 14 Feb 2011 14:35:42 GMT https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215214#M68694 2011-02-14T14:35:42Z Nested IF statements - HELP!!! https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215215#M68695 <HTML><HEAD></HEAD><BODY><P>replace the "AND IF(" with "AND"<BR />and remove 4 brackets "))))" and the end - this should do</P><P>HTH<BR />Peter</P></BODY></HTML> Mon, 14 Feb 2011 14:39:42 GMT https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215215#M68695 prieper 2011-02-14T14:39:42Z Nested IF statements - HELP!!! https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215216#M68696 <HTML><HEAD></HEAD><BODY><P>Please try this and let me know:</P><P>If (LEN(TRIM(sourceBL)) &lt;&gt; 0 AND LEN(TRIM(sourcePortfolio)) &lt;&gt; 0, 'ActiveBDS' ,<BR /> IF(LEN(TRIM(sourceBL)) = 0 AND LEN(TRIM(sourcePortfolio)) &lt;&gt; 0, 'NotActiveBDS' ,<BR /> IF(LEN(TRIM(sourceBL)) = 0 AND LEN(TRIM(sourcePortfolio)) = 0, 'Error',<BR /> IF(LEN(TRIM(sourceBL)) &lt;&gt; 0 AND LEN(TRIM(sourcePortfolio)) = 0, 'NotAssignedinPortfolio', 'XXXXX')))) as Status</P></BODY></HTML> Mon, 14 Feb 2011 14:44:44 GMT https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215216#M68696 2011-02-14T14:44:44Z Nested IF statements - HELP!!! https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215217#M68697 <HTML><HEAD></HEAD><BODY><P>Thx! Helped a lot!</P></BODY></HTML> Mon, 14 Feb 2011 14:47:21 GMT https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215217#M68697 2011-02-14T14:47:21Z Nested IF statements - HELP!!! https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215218#M68698 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thiago</P><P>Tyr this,</P><P></P><P></P><P></P><P></P><BR /><BR /> <BR /><BR /> <P></P><P></P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">=</P><P></P>IF<B>(</B> LEN<B>(</B>TRIM<B>(</B>sourceBL)) <B>&lt;&gt;</B> 0 <B>,</B> IF<B>(</B> LEN<B>(</B>TRIM<B>(</B>sourcePortfolio)) <B>&lt;&gt;</B> 0<B>,</B> 'ActiveBDS' <P></P><P style="font-weight: bold">,</P><BR /><BR /> <P>IF</P><P></P><P></P><B>(</B> LEN<B>(</B>TRIM<B>(</B>sourceBL)) <B>=</B> 0 <B>,</B> IF<B>(</B> LEN<B>(</B>TRIM<B>(</B>sourcePortfolio)) <B>&lt;&gt;</B> 0<B>,</B> 'NotActiveBDS' <P></P><P style="font-weight: bold">,</P><BR /><BR /> <P>IF</P><P></P><P></P><B>(</B> LEN<B>(</B>TRIM<B>(</B>sourceBL)) <B>=</B> 0 <B>,</B> IF<B>(</B> LEN<B>(</B>TRIM<B>(</B>sourcePortfolio)) <B>=</B> 0<B>,</B> 'Error' <P></P><P style="font-weight: bold">,</P><BR /><BR /> <P>IF</P><P></P><P></P><B>(</B> LEN<B>(</B>TRIM<B>(</B>sourceBL)) <B>&lt;&gt;</B> 0 <B>,</B> IF<B>(</B> LEN<B>(</B>TRIM<B>(</B>sourcePortfolio)) <B>=</B> 0<B>,</B> 'NotAssignedinPortfolio'<B>,</B> 'XXXXX'<B>)))))))) as Status</B><BR /><BR /> <BR /><BR /> <P></P><P>Regards</P><P>Kaushal Mehta</P></BODY></HTML> Mon, 14 Feb 2011 14:55:01 GMT https://community.qlik.com/t5/QlikView/Nested-IF-statements-HELP/m-p/215218#M68698 kaushalview 2011-02-14T14:55:01Z