Rank Between Values

[#1]

Hi, I'm new to Qlikview and need help with a rank function.  I'm trying to rank between values.  For example, the store Ranking is from 1 to 391 based on YTD Sales.  I would like to see the total YTD Sales for the stores ranked between 50 and 100.  I was trying the following but obviously I'm missing something.

=aggr(if(Rank(sum([YTD POS Sales]))<=50and(sum([YTD POS Sales]))>=100,[Store Nbr]),[Store Nbr])

Thank you in advance!

[#2]

Thank you! That worked. Thanks for all your help.

Francesca GomesDirector of Customer Relations

Merchandise Solutions

1100 Burloak Drive, Suite 300

Burlington, ON L7L 6B2

Ph. 905-336-8969

www.merchandise-solutions.com

On Mon, Jun 30, 2014 at 11:00 PM, Vlad Gutkovsky <qcwebmaster@qlikview.com>

[ThornOfCrowns]

Please mark an answer as correct to aid others who may come searching in future.