
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not Equal condition in Set analysis
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Only({<BasePrice -= {'Price'}>}Supervisor)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
It shows the "error in the Calculated dimension " error message.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create calculated dimension as
aggr(Only({<Supervisor-={"=BasePrice=Price"}>}Supervisor),Supervisor)
or Expression
Only({<Supervisor-={"=BasePrice=Price"}>}Supervisor)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
