topic Re: How do I do <> in set analysis? in QlikView

How do I do <> in set analysis?

Wed, 19 Sep 2012 11:41:40 GMT

I am trying to load everything in a set analysis statement except one specific and I can't use <>. How do I do it?

Re: How do I do <> in set analysis?

Miguel_Angel_Baeyens — Wed, 19 Sep 2012 11:45:35 GMT

Hi,

Use the "-=" operator (it will show as expression error, but it's a bug):

Sum({< Employee -= {'Fred'} >} Sales)

Hope that helps.

Miguel

Re: How do I do <> in set analysis?

Wed, 19 Sep 2012 11:49:39 GMT

Thanks Miguel, much appreciated.

Re: How do I do <> in set analysis?

oxtontom — Thu, 20 Sep 2012 10:03:25 GMT

Hey mrpjspencer,

I know Miguel has already answered the question with the corrent answer but I often get frustrated that it the "-=" operator will show as a bug so I tend to use this.

Sum(

{

Employee= {'*'} - {''Fred''}

} Sales)

It's a longer way to do it but it means you won't see expression errors.

Thanks

Tom

Re: How do I do <> in set analysis?

Thu, 20 Sep 2012 12:45:29 GMT

Thanks, not to fussed about the cosmetics of it as long as it works. Have Qlikview been told about this bug?

Paul.

Re: How do I do <> in set analysis?

Miguel_Angel_Baeyens — Thu, 20 Sep 2012 13:30:15 GMT

Hi Paul,

Yes, we know about it. It happened in previous versions and for some reason it keeps happening but the expression works just fine irrespective what the syntax check underlines in red. Hopefully it will be fixed in the coming release.

Regards,

Miguel

Re: How do I do <> in set analysis?

Tue, 09 Oct 2012 12:05:03 GMT

Ive just realised ive got a problem.

avg

({<Region={[SW],[SE],[KE]},Commercial_Domestic={[Domestic]},Water_Supplier_Text_SW-={[Southern Water]},Waste_Water_Receiver_Text_SW={[Southern Water]

}>}Amount)

See where the writing is Black, its not taking those parts as part of the calculation in my set analysis and is throwing my figures off

Can anyone help?

Re: How do I do <> in set analysis?

Miguel_Angel_Baeyens — Tue, 09 Oct 2012 13:26:37 GMT

Hi,

Assuming that in your expression above "SW", "SE", "Domestic" and so are literal values of fields, the syntax should be:

Avg({< Region = {'SW', 'SE', 'KE'}, Commercial_Domestic = {'Domestic'}, Water_Supplier_Text_SW -= {'Southern Water'}, Waste_Water_Receiver_Text_SW = {'Southern Water'
} >} Amount)

More on how to use quotes properly in set analysis can be found in this post, among some others...

Hope that helps.

Miguel