topic Re: Does Not Equal in QlikView

Does Not Equal

Wed, 12 Aug 2015 12:13:46 GMT

Hi all,

I have a straight table where I'm trying to display only certain customer names. I used a calculated expression with an aggr(only function and set analysis with -= what I want to exclude but it doesn't seem to be working. Any suggestions?

Thank you in advance!

Re: Does Not Equal

Kushal_Chawda — Wed, 12 Aug 2015 12:14:47 GMT

what is condition?

Re: Does Not Equal

Wed, 12 Aug 2015 12:21:00 GMT

I'm not sure what you mean but below is the calculated dimension expression I used, replacing the actual fields with Attribute1 and Attribute2.

=aggr(only({<Attribute1=P({<Attribute1-={"Others"}>}Attribute1)>}Attribute2),Attribute2)

Hopefully this helps!

Re: Does Not Equal

jonathandienst — Wed, 12 Aug 2015 12:21:49 GMT

It would help if you could show us sample data and the expression that you are trying to use. Probably the Only() function is getting multiple values and therefore returns null.

You could also use something like:

If(Match(Product, 'A', 'B', 'C') = 0, Product)

//do not display A, B or C

Re: Does Not Equal

maximiliano_vel — Wed, 12 Aug 2015 12:26:18 GMT

If you are trying to get all the possible values for Attribute1 tha does not include "Others", you should try

=aggr(only({<Attribute1=E({<Attribute1={"Others"}>}Attribute1)>}Attribute2),Attribute2)

Re: Does Not Equal

jonathandienst — Wed, 12 Aug 2015 12:27:11 GMT

Elizabeth Brate wrote:

=aggr(only({<Attribute1=P({<Attribute1-={"Others"}>}Attribute1)>}Attribute2),Attribute2)

That does not look at all like your original question. Is this what you mean?

If(Attribute1 = 'Others', Attribute2, Attribute1)

I am not sure how that will play though. Is there a 1-1 correspondence between Attribute1 and Attribute2? If not, then I don't think that will work.

Re: Does Not Equal

sunny_talwar — Wed, 12 Aug 2015 12:29:21 GMT

What is the expression you are using?

Re: Does Not Equal

Wed, 12 Aug 2015 12:37:59 GMT

=aggr(only({<Attribute1=P({<Attribute1-={"Others"}>}Attribute1)>}Attribute2),Attribute2)

Maximiliano, you was on the right track. I actually figured it out as I was typing this post. I just needed to suppress null values.

Thank you everyone for your suggestions!