topic Re: Bottom Rank in QlikView

Bottom Rank

Anonymous — Sat, 09 Nov 2013 22:16:52 GMT

Trying to show bottom 10 ranked values by using calculated dimension:

=if(Aggr(Rank(-(sum({<Week={"<=$(vCurrentWeek)"}, Year={$(vCurrentYear)}>} Sales)-

sum({<Week={"<=$(vCurrentWeek)"}, Year={$(=vCurrentYear-1)}>} Sales))), Clients) <= 10, Clients)

It work fine as long as the resulting value is negative but doesn't show if it's 0 or positive.

Sun, 10 Nov 2013 11:41:37 GMT

The easiest way of doing this is using the Dimension Limits tab from the graph:

rustyfishbones — Sun, 10 Nov 2013 11:54:43 GMT

=if(Aggr(Rank(-(sum({<Week={"<=$(vCurrentWeek)"}, Year={$(vCurrentYear)}>} Sales)-

sum({<Week={"<=$(vCurrentWeek)"}, Year={$(=vCurrentYear-1)}>} Sales))), Clients) <= 10, Clients)

Try without the - before sum

=if(Aggr(Rank(sum({<Week={"<=$(vCurrentWeek)"}, Year={$(vCurrentYear)}>} Sales)-

sum({<Week={"<=$(vCurrentWeek)"}, Year={$(=vCurrentYear-1)}>} Sales)), Clients) <= 10, Clients)