topic Re: Sum within Set Expression in QlikView https://community.qlik.com/t5/QlikView/Sum-within-Set-Expression/m-p/516262#M192748 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Count({&lt;WeekNum={"&lt;=$(vCurrWeek)"}, Year={$(vCurrYear)}, IDs={"=Sum(Sales)&gt;=10000"}&gt;} IDs))</SPAN></P></BODY></HTML> Fri, 20 Dec 2013 17:52:55 GMT Clever_Anjos 2013-12-20T17:52:55Z Sum within Set Expression https://community.qlik.com/t5/QlikView/Sum-within-Set-Expression/m-p/516261#M192747 <HTML><HEAD></HEAD><BODY><P>Trying to calculate the Count of IDs where sum of Sales by IDs should be greater or equal to 10,000.</P><P></P><P>Count({&lt;WeekNum={"&lt;=$(vCurrWeek)"}, Year={$(vCurrYear)}, Aggr(Sum({&lt;WeekNum={"&lt;=$(vCurrWeek)"}, Year={$(vCurrYear)}&gt;} Sales), IDs)={"&gt;=10000"}&gt;} IDs))</P></BODY></HTML> Fri, 20 Dec 2013 17:49:30 GMT https://community.qlik.com/t5/QlikView/Sum-within-Set-Expression/m-p/516261#M192747 Anonymous 2013-12-20T17:49:30Z Re: Sum within Set Expression https://community.qlik.com/t5/QlikView/Sum-within-Set-Expression/m-p/516262#M192748 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Count({&lt;WeekNum={"&lt;=$(vCurrWeek)"}, Year={$(vCurrYear)}, IDs={"=Sum(Sales)&gt;=10000"}&gt;} IDs))</SPAN></P></BODY></HTML> Fri, 20 Dec 2013 17:52:55 GMT https://community.qlik.com/t5/QlikView/Sum-within-Set-Expression/m-p/516262#M192748 Clever_Anjos 2013-12-20T17:52:55Z