topic Re: Nested If statement in Script! in QlikView

Nested If statement in Script!

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

Hi Dear All!

I need to create a simple table box to arrange how set of people have visited set of countries as per a set schedule & how the plan was changed & carried out the visits. In the process, based on the dimensions I have created a if statement which gives some scripting errors while loading. Can some one see where I have gone wrong & correct me.

Thanks in advance

Neville

Date_Plan:

LOAD

[Person to visit],

[place to visit],

[Set Date Plan],

[Person visited],

[Place visited],

[Ammended Dat Plan],

IF( [Person to visit]= [Person visited] AND [Set Date Plan]= [Ammended Dat Plan],'ON_DATE_VISIT',IF( [Person to visit]= [Person visited] AND [Set Date Plan]> [Ammended Dat Plan],'ADVANCE_VISIT',

IF( [Person to visit]= [Person visited] AND [Set Date Plan]< [Ammended Dat Plan],'LATE_DATE_VISIT' AND IF( [Person to visit]<> [Person visited] AND [Set Date Plan]= [Ammended Dat Plan],'ON_DATE_SUB_VISIT',

IF( [Person to visit]<> [Person visited] AND [Set Date Plan]< [Ammended Dat Plan],'LATE_DATE_SUB_VISIT', IF( [Person to visit]<> [Person visited] AND [Set Date Plan]> [Ammended Dat Plan],'ADVANCE_SUB_VISIT',

FROM (ooxml, embedded labels, table is Sheet1);

Re: Nested If statement in Script!

Anonymous — Fri, 03 Nov 2017 14:59:12 GMT

Immediately I can tell you haven't closed any of your parenthesis.

You should have at least 6 closing parentheses at the end if I counted right.

Re: Nested If statement in Script!

nevilledhamsiri — Fri, 03 Nov 2017 15:57:03 GMT

Please show me with explanation where it is wrong

Regds

Neville

Re: Nested If statement in Script!

sunny_talwar — Fri, 03 Nov 2017 15:58:59 GMT

May be this

If([Person to visit] = [Person visited],

If([Set Date Plan] = [Ammended Dat Plan], 'ON_DATE_VISIT',

If([Set Date Plan] > [Ammended Dat Plan], 'ADVANCE_VISIT',

If([Set Date Plan] < [Ammended Dat Plan], 'LATE_DATE_VISIT')))

If([Person to visit] <> [Person visited],

If([Set Date Plan] = [Ammended Dat Plan], 'ON_DATE_SUB_VISIT',

If([Set Date Plan] < [Ammended Dat Plan], 'LATE_DATE_SUB_VISIT',

If([Set Date Plan] > [Ammended Dat Plan], 'ADVANCE_SUB_VISIT')))))