How to use calculaed dimension or bring TOP 10 dimension limit in PIVOT Table

[Anonymous]

Hi Friends, We have the dimension limit in Charts but I dont see an option to limit dimension (TOP 10) in PIVOT Table object.

I have 2 columns as below.

1. IT Team

2. Ticket #

I am having a PIVOT Table which will show us IT Team and Count of Tickets as below.

IT Team A = 200

IT Team B = 300

and so on...

But the PIVOT Table shows the complete list. is there a way to create the PIVOT table to show only TOP 10 IT teams based on count of tickets handled?

[malini_qlikview]

you can use Rank function to show the top n values,

If(Rank(Count(Ticket)<=10,Rank(Count(Ticket))

[Kushal_Chawda]

create expression

=Count({<[IT Team] ={"=rank(count(Ticket),4)<=10"}>}Ticket)

[#4]

Vijay,

use below calculated dimension

=if(aggr(rank(count(Ticket #)),IT Team)<=10,IT Team)

it will first calculate the count of Tickets,

then aggregate it based on IT team,

then compare it with 10 (top 10)

then display the IT Team as dimension.

[Digvijay_Singh]

See attached -