RANK function help

[Qlik1_User1]

Hi All,

Is it possible to break the grouping of rank like  instead of 8-15 result should be like 8,9,10 and so on, even if the field(sales) on which rank calculation is done has same values like in this case '0'.
RANK(TOTAL Sum({<id={'a','e'},year={"$(=max(year))"}>} (sales)))

[HugoRomeira_PT]

Hello,

You can achieve this with the following expression:

Num(RANK(TOTAL Sum({<id={'a','e'},year={"$(=max(year))"}>} (sales)), 4))

Hope it helps!