topic Not Equal To in Chart Sheet Object in QlikView

Not Equal To in Chart Sheet Object

Wed, 16 May 2012 12:12:17 GMT

Hi,

Apologies - I have read the various posts on "Not Equal To" but have still failed to get my expression working on a Chart Sheet Object.

The expression I am seeking to fix:

=COUNT({<

STATUS={'Completed','Checked'},

TASK_TYPE={'Build'},

TASK_REF NOT EQUAL TO {'TR0123456789','TR9876543210'}

>}TASK_REF)

Please could someone suggest the operator / syntax that I could use...

Many thanks,

Jonathan

Re: Not Equal To in Chart Sheet Object

swuehl — Wed, 16 May 2012 12:18:01 GMT

Right, I believe this is one of the questions that appear repeatingly here.

Try

=COUNT({<

STATUS={'Completed','Checked'},

TASK_TYPE={'Build'},

TASK_REF -= {'TR0123456789','TR9876543210'}

>}TASK_REF)

Edit:

A common mistake is to look at the equal sign in above set expression as a comparison operator. You don't compare field STATUS to values Completed or checked, you create a set (like a selection set, so it's more a set assignment than a comparison).

In a similar way, if you want to create a set that does not contain value, you remove them from your current selection using -= (minus equal) the short form for TASK_REF = TASK_REF - {'TR0123456789'}

Hope this helps,

Stefan

Re: Not Equal To in Chart Sheet Object

Wed, 16 May 2012 12:33:28 GMT

Hi Stefan,

Unfortunately I had tried this syntax already and it shows an error on the "-=" operator (see screenshot).

I have also tried it with and without the spaces.

I am currently using QlikView v10 if that helps.

Many thanks,

Jonathan

Not Equal To in Chart Sheet Object

swuehl — Wed, 16 May 2012 12:36:27 GMT

For any reason, I can't open your attached image.

There is a bug in the expression editor that marks the -= as error, but the expression is valid.

Just give it a try.

Re: Not Equal To in Chart Sheet Object

Wed, 16 May 2012 13:53:13 GMT

Hi Stefan,

Thanks for your help - all working.

Also - thanks for the additional info on comparison operators vs Sets.

Thanks,

Jonathan