topic Re: Sum of Top 10 that ignores certain filters in QlikView https://community.qlik.com/t5/QlikView/Sum-of-Top-10-that-ignores-certain-filters/m-p/57869#M769485 <HTML><HEAD></HEAD><BODY><P>So, then add it... may be like this</P><P></P><P><STRONG>=Sum({&lt;[Recruiter Full Name] = {"=Rank(Sum(<SPAN style="color: #ff0000;">{&lt;[Recruiter SID]&gt;}</SPAN> [New Apps]) &lt;= 10)"}, [EVENT ID] = {'OPN','SSH'}, [Month Number] = {'=$(#vSelectedMonthNumber)'}, [Event Month], [Recruiter SID]&gt;}[New Apps])</STRONG></P></BODY></HTML> Tue, 05 Jun 2018 14:58:34 GMT sunny_talwar 2018-06-05T14:58:34Z Sum of Top 10 that ignores certain filters https://community.qlik.com/t5/QlikView/Sum-of-Top-10-that-ignores-certain-filters/m-p/57868#M769484 <HTML><HEAD></HEAD><BODY><P>Hello - I am trying to write a set analysis expression that would show a sum of the top 10 recruiters based on recruiter's number of new applications.&nbsp; I want that number to stay constant no matter what Recruiter SID filter is applied.&nbsp; I am using the formula below but because 'Recruiter SID=' isn't applied to the rank portion of the expression it is not working the way I would like it to.&nbsp; Any assistance would be greatly appreciated!</P><P></P><P>=sum({&lt;[Recruiter Full Name]={"=(Rank(SUM([New Apps]))&lt;=10)"},[EVENT ID]={'OPN','SSH'},[Month Number]={'=$(#vSelectedMonthNumber)'},[Event Month]=,[Recruiter SID]= &gt;}[New Apps])</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sum-of-Top-10-that-ignores-certain-filters/m-p/57868#M769484 Anonymous 2020-11-25T16:16:04Z Re: Sum of Top 10 that ignores certain filters https://community.qlik.com/t5/QlikView/Sum-of-Top-10-that-ignores-certain-filters/m-p/57869#M769485 <HTML><HEAD></HEAD><BODY><P>So, then add it... may be like this</P><P></P><P><STRONG>=Sum({&lt;[Recruiter Full Name] = {"=Rank(Sum(<SPAN style="color: #ff0000;">{&lt;[Recruiter SID]&gt;}</SPAN> [New Apps]) &lt;= 10)"}, [EVENT ID] = {'OPN','SSH'}, [Month Number] = {'=$(#vSelectedMonthNumber)'}, [Event Month], [Recruiter SID]&gt;}[New Apps])</STRONG></P></BODY></HTML> Tue, 05 Jun 2018 14:58:34 GMT https://community.qlik.com/t5/QlikView/Sum-of-Top-10-that-ignores-certain-filters/m-p/57869#M769485 sunny_talwar 2018-06-05T14:58:34Z