Select Last n rows by groups in qlikview ?

[wallacechen]

Hi,

Is it possible in expression for barchart able to select last n row by groups ?

for example:

Group     Period 

Group1     0

Group1     1

Group2     0

Group2     1

Group2     1

Group2     2

Group3     1

Group3     2

Group3    3

Group3    4

Group by group to select last 2 rows to plot barchart in expression:

Group    Period

Group1    0

Group1    1

Group2    1

Group2    2

Group3    3

Group4    4

[sunny_talwar]

Maye be using if statement with the Rank() function or RowNo() with Aggr() function to do this...

Aggr(Rank