Nested IF statement - Error in expression:')' expected

Fri, 30 Jul 2010 14:04:30 GMT

Hi,

I am attempting a nested if statement with two conditions, but am receiving the following error message:

Error in expression:')' expected

Any ideas why this isn't working would be gratefully received.

The statement is as follows:

([Current Status]='Authorised' AND [No. Of days from date reported]=< 21,'On track',if([Current Status]='Processed' AND [No. Of days from date reported]=< 21,'On track',if([Current Status]='Checking' AND [No. Of days from date reported]=< 7,'On track',if([Current Status]='Draft' AND [NO. Of days from date reported]=< 7,'On track',if([Current Status]='Closed','Closed','Overdue'))))) as OnTrack,

Thanks!

Nested IF statement - Error in expression:')' expected

Fri, 30 Jul 2010 15:19:05 GMT

You have your less than or equal tos reversed. You need:

<=

You're using =<

Nested IF statement - Error in expression:')' expected

Fri, 30 Jul 2010 17:15:46 GMT

Thanks - Problem solved!

topic Nested IF statement - Error in expression:')' expected in QlikView

Nested IF statement - Error in expression:')' expected

Nested IF statement - Error in expression:')' expected

Nested IF statement - Error in expression:')' expected