topic Top n results in pivot table in QlikView

Top n results in pivot table

deepakqlikview_123 — Mon, 02 Jun 2014 04:30:02 GMT

hi all,

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

Thanks,

Deepak

robert_mika — Mon, 02 Jun 2014 04:41:42 GMT

look here

tresB — Mon, 02 Jun 2014 04:45:46 GMT

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

jsingh71 — Mon, 02 Jun 2014 04:48:34 GMT

Hi Deepak,

Foolow the below link. This will solve your problem.

--Jai

anbu1984 — Mon, 02 Jun 2014 04:51:35 GMT

Check this app

amit_saini — Mon, 02 Jun 2014 04:58:12 GMT

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,