Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table

hi i am trying to to display the top 10 highest number of values which is in the pivot table is there any way that i can do this. i have attached an image of the pivot table.

can some one plz help me much appreciated..

thank you in advance Untitled.png

12 Replies
eduardo_sommer
Partner - Specialist
Partner - Specialist

You can change the expression, from Count(src) to if(rank(Count(src)<11,Count(src))

Eduardo

Not applicable
Author

sorry this is not working i am getting an empty table

Not applicable
Author

can u share ur qvw file?

eduardo_sommer
Partner - Specialist
Partner - Specialist

Another possibility is to change from pivot table to straight table (considering you have oly one dimension in your table) and check 'Restrict which values are displayed using the first expression, in Dimension Limits tab of the properties of the straight table. Also set 10 as  the largest n Values and unmark the Show Others option in the same tab.

Eduardo

Not applicable
Author

try this in pivot table =if(rank(Sum (src))<=10,sum(src),0)

amit_saini
Master III
Master III

Hi Shalani,

Try this:

=aggr(if(Rank(sum(Investment))<=10,Investment),Investment) (For calculating Top 10)


Thanks,

AS

Not applicable
Author

this gives me the correct answr but i am getting a total count on the 1st row i dnt want that count 😕

Not applicable
Author

hey this worked but the correct one is =if(rank(Count (src))<=10,Count(src),0)

thank you so much for your help

Not applicable
Author

is there any possible way of displaying the average next to each count??