topic Ignore filter using aggr and concat in App Development https://community.qlik.com/t5/App-Development/Ignore-filter-using-aggr-and-concat/m-p/1794490#M62245 <P>Dear All,</P><P>My expression is</P><LI-CODE lang="markup">concat(Aggr(if(Rank(num#(OscarWon)) =1, title),title),'; ')</LI-CODE><P>which returns the movies with the highest number of&nbsp; Oscars and if there are more than one, it concatenates them using ";".</P><P>My question is how I can ignore filter in this expression for all dimensions. I tried several set expressions but none of them worked.</P><P>Thank you so much and regards...</P> Thu, 25 Mar 2021 14:17:20 GMT kncb 2021-03-25T14:17:20Z Ignore filter using aggr and concat https://community.qlik.com/t5/App-Development/Ignore-filter-using-aggr-and-concat/m-p/1794490#M62245 <P>Dear All,</P><P>My expression is</P><LI-CODE lang="markup">concat(Aggr(if(Rank(num#(OscarWon)) =1, title),title),'; ')</LI-CODE><P>which returns the movies with the highest number of&nbsp; Oscars and if there are more than one, it concatenates them using ";".</P><P>My question is how I can ignore filter in this expression for all dimensions. I tried several set expressions but none of them worked.</P><P>Thank you so much and regards...</P> Thu, 25 Mar 2021 14:17:20 GMT https://community.qlik.com/t5/App-Development/Ignore-filter-using-aggr-and-concat/m-p/1794490#M62245 kncb 2021-03-25T14:17:20Z Re: Ignore filter using aggr and concat https://community.qlik.com/t5/App-Development/Ignore-filter-using-aggr-and-concat/m-p/1794499#M62246 <LI-CODE lang="markup">concat({1}Aggr(if(Rank(sum({1}OscarWon)) =1, title),title),'; ')</LI-CODE> Thu, 25 Mar 2021 14:30:13 GMT https://community.qlik.com/t5/App-Development/Ignore-filter-using-aggr-and-concat/m-p/1794499#M62246 rwunderlich 2021-03-25T14:30:13Z