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

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

vikasshana — Fri, 19 Jan 2018 13:00:35 GMT

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

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

Anil_Babu_Samineni — Fri, 19 Jan 2018 13:11:55 GMT

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

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

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

sunny_talwar — Fri, 19 Jan 2018 13:13:47 GMT

Use Pick function instead of if

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

vikasshana — Fri, 19 Jan 2018 13:25:43 GMT

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

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

sunny_talwar — Fri, 19 Jan 2018 13:27:01 GMT

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

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

vikasshana — Fri, 19 Jan 2018 13:34:24 GMT

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',)))

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

sunny_talwar — Fri, 19 Jan 2018 13:48:19 GMT

Try like this:

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

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

vikasshana — Tue, 23 Jan 2018 16:27:00 GMT

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