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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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
MVP
MVP

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

View solution in original post

1 Reply
rwunderlich
MVP
MVP

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