topic Re: Set Analysis - "Does not equal" in QlikView

Set Analysis - "Does not equal"

stuwannop — Fri, 25 Jan 2013 09:25:39 GMT

Hi Everyone

This is just quick question. When I'm using set analysis in an expression to OMIT certain data, I am using the term "-=". Example:

sum({$<TEAM -={'Sage','CRM','Technical','Network Serv','MRM','Pegasus','Project Management','Sharepoint','Navision','Project Management'}>}APPTime)

The expression works OK but the formula is underlined as if it's an error. It's a minor inconvenience if I'm trying to validate the rest of an expression, am I doing it the correct way or is there another way of doing it?

Thanks

Stuart

Re: Set Analysis - "Does not equal"

jonathandienst — Fri, 25 Jan 2013 09:37:31 GMT

Stuart

It is correct, but there is a bug in the syntax check. You could also write this as follows to avoid the problem:

sum({$<TEAM ={'*'} - {'Sage','CRM','Technical','Network Serv','MRM','Pegasus','Project Management','Sharepoint','Navision','Project Management'}>} APPTime)

Regards

Jonathan

Re: Set Analysis - "Does not equal"

stuwannop — Fri, 25 Jan 2013 09:53:45 GMT

Thanks Jonathan much appreciated. Didn't realise set analysis could work like that!

Cheers

Stu

Re: Set Analysis - "Does not equal"

musketeers — Wed, 24 Jul 2013 14:14:59 GMT

Hi Stuart and Jonathan,

I have similar problem but in the Dimension.

I have to set Region as a dimension. But I want to exclude some of the regions.

So I am writing like this

=Only({<PROD_LEVEL-={'ABC'}>}region)

But in the multi box, I am not getting any value.

Please help me in this issue.

Thanks

Rajneesh

Re: Set Analysis - "Does not equal"

Anonymous — Wed, 09 Nov 2016 11:58:42 GMT

Hello,

This works just fine, but what if the dimensions has NULL values on it? The {*} does not take it on notice at all.

Just was wondering why my figures were showing show odd things, but it was because of that.

I am trying to figure out now, how to get the null values included to the {*} value.

Cheers,

Niko