Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
kncb
Contributor
Contributor

Ignore filter using aggr and concat

Dear All,

My expression is

concat(Aggr(if(Rank(num#(OscarWon)) =1, title),title),'; ')

which returns the movies with the highest number of  Oscars and if there are more than one, it concatenates them using ";".

My question is how I can ignore filter in this expression for all dimensions. I tried several set expressions but none of them worked.

Thank you so much and regards...

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

concat({1}Aggr(if(Rank(sum({1}OscarWon)) =1, title),title),'; ')

View solution in original post

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

concat({1}Aggr(if(Rank(sum({1}OscarWon)) =1, title),title),'; ')