Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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