topic Syntax for not equal to / different from in QlikView

Syntax for not equal to / different from

guyvermeiren — Fri, 08 Oct 2010 13:55:43 GMT

Hello,

I want to use a formula where I have as result all values except one. I found that the syntax for different from is " -=".

I tried the next :

=if(Opportunity.Status-='On Hold',null(),Opportunity.Status) but this gives me " error in expression.

What's wrong ??

Thanks,

Guy

Fri, 08 Oct 2010 13:56:51 GMT

This syntax is for Set analysis.

For the if statement it is:

=if(Opportunity.Status<>'On Hold',null(),Opportunity.Status)

Rgds,

Sébastien

guyvermeiren — Fri, 08 Oct 2010 14:04:59 GMT

Sébastien,

Thanks, this works.

Kind regards,

Guy