topic Re: How to use calculaed dimension or bring TOP 10 dimension limit in PIVOT Table in QlikView

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

Anonymous — Tue, 06 Oct 2015 09:57:56 GMT

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 — Tue, 06 Oct 2015 14:25:08 GMT

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

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

Kushal_Chawda — Tue, 06 Oct 2015 14:28:32 GMT

create expression

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

Wed, 07 Oct 2015 07:59:13 GMT

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 — Wed, 07 Oct 2015 08:10:53 GMT

See attached -