topic Not Equal in QlikView

Not Equal

Wed, 29 Sep 2010 16:54:27 GMT

I'm sure there's a really simple way to do this but I'm having a hard time finding a solution.

I'm trying to write an expression that says "count this if the [RR Code] is not equal to "Not Listed"

These are some of the ones I came up with, but either they don't work at all or they don't actually take the "Not Listed" out.

count({$<[RR Code]<>{"Not Listed"}>} [RR Code])

count({$<[RR Code]={"<>Not Listed"}>} [RR Code])

count([RR Code]<>'Not Listed')

pover — Wed, 29 Sep 2010 16:58:41 GMT

Try count({$<[RR Code] -={"Not Listed"}>} [RR Code])

Regards.

Wed, 29 Sep 2010 17:00:51 GMT

how about

sum(if([RR Code] <> 'Not Listed',1,0))

Wed, 29 Sep 2010 17:01:25 GMT

Works like a charm. Thanks Karl.

Emma yours works great as well. 🙂