topic Error in Expression !$@&^# in QlikView

Error in Expression !$@&^#

Wed, 15 Dec 2010 13:07:18 GMT

Hello again all,

I keep getting this while creating an expression!

count(Maintenance)

=count(if(StartDate <= CurrentDate) and (StartDate <= CurrentDate) and

(StartDate >= CurrentDate) and (StartDate >= CurrentDate));

What am I doing wrong!?!

Thanks in Advance!

Error in Expression !$@&^#

Wed, 15 Dec 2010 13:16:53 GMT

What ??

Let me reduce your if condition to its effective part:

StartDate = CurrentDate

Please try to add some more details what you try to do.

Error in Expression !$@&^#

Wed, 15 Dec 2010 13:21:15 GMT

Hi,

You can write in this way

count(if(startDate<=CurrentDate and startDate>=CurrentDate ,Maintenance))

You have written "startDate<=CurrentDate " two times which i am not able to understand i think this should be one time only if condition is same and fields are same.

Regards,

Ravi

Error in Expression !$@&^#

Wed, 15 Dec 2010 13:28:52 GMT

MY BAD SORRY! IT SHOULD BE MORE LIKE THIS:

=count(if(StartDate <= CurrentDate) and (StartTime <= CurrentTime) and

(EndDate >= CurrentDate) and (EndTime >= CurrentTime));

SV:Re: Error in Expression !$@&^#

Wed, 15 Dec 2010 15:57:27 GMT

Hi!

It looks like your expression is not completed. To make it easier I will break it down:

=count(

if(

StartDate <= CurrentDate and StartTime <= CurrentTime and EndDate >= CurrentDate and EndTime >= CurrentTime

,Maintenance

)

);

Remember the if statement works like:

if( criteria=met

,THEN

,ELSE)

Jakob Berglund