Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ZoeM
Contributor II

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. 

2 Replies
Community Manager
Community Manager

Re: Showing only the Top 5 results in a Pivot Chart

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

Sue Macaluso
Highlighted
ZoeM
Contributor II

Re: Showing only the Top 5 results in a Pivot Chart

Hi Sue.

This is for QlikView