topic Week Rank in QlikView

Week Rank

Anonymous — Wed, 27 Nov 2013 16:23:56 GMT

Trying to show the Rank of current week based on Sum of Sales and Region. Attached is a sample.

I need to show only current week data but also it's Rank with respect to previous weeks of the year.

Thank you.

Gysbert_Wassenaar — Wed, 27 Nov 2013 16:46:05 GMT

Try: only({<Week={$(vCurrWeek)},Year={$(vCurrYear)}>}aggr(NODISTINCT rank(total sum({<Year={$(vCurrYear)}>}Sales)),Week))

Anonymous — Wed, 27 Nov 2013 17:48:23 GMT

Thank you Gysbert!

I just had to add Region and take out Total:

only({<Week={$(vCurrWeek)},Year={$(vCurrYear)}>}aggr(NODISTINCT rank(sum({<Year={$(vCurrYear)}>}Sales)), Region, Week))