Error in expression:Too complex, more than 100 levels nesting

[vikasshana]

Hi All,

I'm using 249 IF statements in the Qlikview load statement and receiving the below error message. I've googled the error message and have read in some blogs and some one stated that there are only 100 IF statements allowed in the load statement.

How I can resolve this issue?

Regards,

Vikas

[Anil_Babu_Samineni]

Read here also https://community.qlik.com/thread/179549

Probably, hic‌ know till how many Nested can work.

[sunny_talwar]

Use Pick function instead of if

[vikasshana]

I tried pick function instead of if and it still says the same.

[sunny_talwar]

Can you share a part of the expression how it looked when you used if and how it looked after you changed to pick?

[vikasshana]

IF:

if(SYSTEM_NAME like '?388*' , 'Jamaica',
if(SYSTEM_NAME like '?392*' , 'Japan',
if(SYSTEM_NAME like '?832*' , 'Jersey',)))

PICK:

pick(SYSTEM_NAME like '?388*' , 'Jamaica',

pick(SYSTEM_NAME like '?392*' , 'Japan',

pick(SYSTEM_NAME like '?832*' , 'Jersey',)))

[sunny_talwar · Accepted solution]

Try like this:

Pick(WildMatch(SYSTEM_NAME, '?388*', '?392*', '?832*'), 'Jamaica', 'Japan', 'Jersey')

[vikasshana]

thanks for the Sunny, It's working...!!!