Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kvijay173
Creator
Creator

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?

4 Replies
malini_qlikview
Creator II
Creator II

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

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

Kush
MVP
MVP

create expression

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

Not applicable

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
Master III
Master III

See attached - ticket.PNG