Not Equal condition in Set analysis

[Anonymous]

Dear All,

i need to write not equal condition to filter  dimensions in set analysis.

Now am using if condition so it take long time to load chart user get hesitate.

if(BasePrice<>Price,Supervisor)

i need to change this into set analysis

Kindly help to achieve this.

Thanks in advance

Regards

Siraj

[MK_QSL]

Only({<BasePrice -= {'Price'}>}Supervisor)

[Anonymous]

Hi

It shows the "error in the Calculated dimension " error message.

[Kushal_Chawda]

Create calculated dimension as

aggr(Only({<Supervisor-={"=BasePrice=Price"}>}Supervisor),Supervisor)

or Expression

Only({<Supervisor-={"=BasePrice=Price"}>}Supervisor)

[MK_QSL]

Let me know where you want to use it and how?

If you want to count, use formula suggested by

Re: Not Equal condition in Set analysis Kush141087

COUNT({<Supervisor = {"=BasePrice = Price"}>}Distinct Supervisor)

If you don't want Distinct, you can ignore it.