Select Last n rows by groups in qlikview ?

wallacechen — Wed, 25 Nov 2020 16:16:04 GMT

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 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

Re: Select Last n rows by groups in qlikview ?

sunny_talwar — Sat, 28 Jul 2018 16:12:36 GMT

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

Aggr(Rank