topic Script Error in QlikView

Script Error

Wed, 05 Aug 2015 03:36:02 GMT

if([Status]<>'YES', or if([Status]<>'NO',

if(Date([fuTureDate])- Date(Today())<90, 'Red')))

Am I doing anything wrong here ?

sunny_talwar — Wed, 05 Aug 2015 03:37:59 GMT

I see an extra comma (,) before or and if clauseafter or

if([Status]<>'YES' or [Status]<>'NO',

if(Date([fuTureDate])- Date(Today())<90, 'Red')))

sunny_talwar — Wed, 05 Aug 2015 03:39:30 GMT

or may be this to simplify it:

=If(WildMatch(Status, 'YES', 'NO'), If(fuTureDate - Today() < 90, 'Red'))

=If(not WildMatch(Status, 'YES', 'NO'), If(fuTureDate - Today() < 90, 'Red'))

qlikmsg4u — Wed, 05 Aug 2015 03:43:03 GMT

=if([Status]<>'YES' or [Status]<>'NO', if(Date([OperativeBeginDate])- Date(Today())<90, 'Red'))