Does Not Equal

[#1]

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!

[Kushal_Chawda]

what is condition?

[#3]

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!

[jonathandienst]

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

[maximiliano_vel]

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)

[jonathandienst]

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.

[sunny_talwar]

What is the expression you are using?

[#8 · Accepted solution]

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