Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Script Error

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

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

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

3 Replies

Re: Script Error

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

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

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

Re: Script Error

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
Valued Contributor

Re: Script Error

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

Community Browser