7 Replies Latest reply: Aug 12, 2015 8:37 AM by Elizabeth Brate

# Does Not Equal

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?

• ###### Re: Does Not Equal

what is condition?

• ###### Re: Does Not Equal

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

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

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

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

What is the expression you are using?

• ###### Re: Does Not Equal

=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!