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: 
ZoeM
Specialist
Specialist

Showing only the Top 5 results in a Pivot Chart

Hello Community.

I was wondering if I could get some help with showing only the top 5 in a pivot chart.

I have a chart which shows the candidates that are repeatedly late and I wanted to show those that are the top late comers. My expression is:

Concat( {$<[#of Days Post VPP]={'>14'},[Date Type]={'VPP Dates'}>} DISTINCT [Main Causal Factor],',')

I have only one Dimension: MY Program.

I am hoping to use a variable that enables the Top 5 to be viewed and if the user wants to see all candidates they can also turn off the variable. 

Any help rendered will be truly appreciated. 

 

Zoe M. 

Labels (4)
2 Replies
Sue_Macaluso
Community Manager
Community Manager

@ZoeM  Is this for QlikView or Sense?  Iw ould like to move this into the correct product forum. Thanks

Sue Macaluso
ZoeM
Specialist
Specialist
Author

Hi Sue.

This is for QlikView