Top n results in pivot table

[deepakqlikview_123]

hi all,

Can u plz tell  me how to show top n and bottom n results in pivot table.

Thanks,

Deepak

[robert_mika]

look here

http://qv-bitz-and-pieces.blogspot.co.uk/2013/03/top-n-records-in-qlikview-straightpivot.html

[tresesco]

Have you searched in the community? You would get many like:

Re: top 5 values in pivote table expressions

TOP 5 in PIVOT TABLE

[jsingh71]

Hi Deepak,

Foolow the below link. This will solve your problem.

http://community.qlik.com/docs/DOC-3862

--Jai

[anbu1984 · Accepted solution]

Check this app

[amit_saini]

Hi Deepak,

Try this:

=aggr(if(Rank(sum(Investment))<=20,Investment),Investment) (For calculating Top 20)

=aggr(if(Rank(-sum(Investment))<=20,Investment),Investment) (For calculating Bottom  20)

or you can also try this:

=rank(sum(Value)) (Rank from highest to lowest)

=rank(-sum(Value)) (Rank in reverse order)

Thanks,

AS