topic Re: Using Not Equal in Set analysis in QlikView

Using Not Equal in Set analysis

triciagdaly — Fri, 20 Jun 2014 17:25:33 GMT

I'm trying to use a not equal comparison in set analysis.... Why will option 1 not work? - Options 2 works fine. Option 3 is using an equal comparison. For option 1, I've also tried single quotes..

option 1. count( {< [Status] -= {'C'} >} [Move ID])

option 2: count(if([Status] <> 'C', [Move ID]))

option 3 (in another expression ) also works. count( {< [Status Description]={"In Progress"} >} [Request Number])

Thanks!

Re: Using Not Equal in Set analysis

swuehl — Fri, 20 Jun 2014 17:36:17 GMT

Tricia,

what do you mean with 'not work'?

If you see a red underlining by the syntax checker, that's a bug in the checker, the expression dialog should say 'expression OK' and evaluate.

Re: Using Not Equal in Set analysis

joshabbott — Fri, 20 Jun 2014 17:38:47 GMT

If you don't want the red squiggly line:

count( {< [Status] = {'*'} - {'C'} >} [Move ID])

Re: Using Not Equal in Set analysis

triciagdaly — Fri, 20 Jun 2014 17:46:16 GMT

Josh,

Can you explain the syntax of your suggestion - which works great! And... why are there red squiggly lines on the expression I was using?

Thanks

Tricia

Re: Using Not Equal in Set analysis

joshabbott — Fri, 20 Jun 2014 17:57:02 GMT

I have never understood why the red squiggly lines are there. I've alway's found that they show up yet it still works in your first expression. It must be a bug as to why it is showing the red lines:

count( {< [Status] -= {'C'} >} [Move ID])

What the one I sent you is doing is taking all values {'*'} and using a set analysis operator of subtraction, removing the 'C' values from all, anything where the status is anything except for C.

Have a great day!