Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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),'; ')