Nested IF statements - HELP!!!

[#1]

Hi everyone!

I inherited a code piece that contains nested IF statements. Issue: somehow it stopped working...

The code is:

IF

( LEN(TRIM(sourceBL)) <> 0 AND IF( LEN(TRIM(sourcePortfolio)) <> 0, 'ActiveBDS'

,

IF

( LEN(TRIM(sourceBL)) = 0 AND IF( LEN(TRIM(sourcePortfolio)) <> 0, 'NotActiveBDS'

,

IF

( LEN(TRIM(sourceBL)) = 0 AND IF( LEN(TRIM(sourcePortfolio)) = 0, 'Error'

,

IF

( LEN(TRIM(sourceBL)) <> 0 AND IF( LEN(TRIM(sourcePortfolio)) = 0, 'NotAssignedinPortfolio', 'XXXXX'))))))) as

Status

I just cannot see the syntax issue by myself...

Please help!

[Anonymous · Accepted solution]

Here is a tool that might be usefull:

http://www.qlikblog.at/tools/Nested-If-Generator.html

Good luck.

[#3]

Error message:

[prieper]

replace the "AND IF(" with "AND"
and remove 4 brackets "))))" and the end - this should do

HTH
Peter

[#5]

Please try this and let me know:

If (LEN(TRIM(sourceBL)) <> 0 AND LEN(TRIM(sourcePortfolio)) <> 0, 'ActiveBDS' ,
IF(LEN(TRIM(sourceBL)) = 0 AND LEN(TRIM(sourcePortfolio)) <> 0, 'NotActiveBDS' ,
IF(LEN(TRIM(sourceBL)) = 0 AND LEN(TRIM(sourcePortfolio)) = 0, 'Error',
IF(LEN(TRIM(sourceBL)) <> 0 AND LEN(TRIM(sourcePortfolio)) = 0, 'NotAssignedinPortfolio', 'XXXXX')))) as Status

[#6]

Thx! Helped a lot!

[kaushalview]

Hi,

Thiago

Tyr this,

=

IF( LEN(TRIM(sourceBL)) <> 0 , IF( LEN(TRIM(sourcePortfolio)) <> 0, 'ActiveBDS'

,

IF

( LEN(TRIM(sourceBL)) = 0 , IF( LEN(TRIM(sourcePortfolio)) <> 0, 'NotActiveBDS'

,

IF

( LEN(TRIM(sourceBL)) = 0 , IF( LEN(TRIM(sourcePortfolio)) = 0, 'Error'

,

IF

( LEN(TRIM(sourceBL)) <> 0 , IF( LEN(TRIM(sourcePortfolio)) = 0, 'NotAssignedinPortfolio', 'XXXXX')))))))) as Status

Regards

Kaushal Mehta