Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script Error

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

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

 

Am I doing anything wrong here ?

1 Solution

Accepted Solutions
sunny_talwar

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

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

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

View solution in original post

3 Replies
sunny_talwar

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

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

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

View solution in original post

sunny_talwar

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
Specialist
Specialist

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