top 3 values

[subbareddykm]

hi all , I have requirement to show top 3 invoice numbers based Company and Region on my expression.

Exp:

For every Company and Region combination I need top 3 invoice numbers by default without any selection.

Can anyone tell me how to achieve this in qlikview ?

[manu1512]

use can aggr function

[subbareddykm]

I tried but no luck

can try with my app?

[trdandamudi]

Please see the attached and hope this helps..

[passionate]

Concate both country and region to form a new column i.e dimension and then use dimension limit or Aggr rank combination

[subbareddykm]

Its not giving the result which I ma expecting .

Example :

For Comp = A and Region = W , I have 6 Inv No ,I want only 3 Inv No which are have high value.

I hope you understood.

[vishsaggi]

May be try like:

= IF(Aggr(Rank(Sum(InvNo)), Comp, Region)<=3, InvNo)

[trdandamudi · Accepted solution]

Please take a look at the attached...