Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

kvijay173
Contributor

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

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?

Tags (1)
4 Replies
malini_qlikview
Contributor II

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

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

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

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

create expression

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

Not applicable

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

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
Honored Contributor III

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

See attached - ticket.PNG