Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
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 Reply
rwunderlich

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