Choose top five values in Measure formulas (QlikSense)

[#1]

Hi ,

I have a measure having following code

pick(match(valuelist('Assessment/Screening','Education-HealthCondition','Relationship','Behavior','ManagementofCare',
'CommunityResources','Navigation','Specialty','Mood','Anxiety','Depression','SleepConcerns',
'PTSD','ADD/ADHD'),

'Assessment/Screening','Education-HealthCondition','Relationship','Behavior','ManagementofCare',
'CommunityResources','Navigation','Specialty','Mood','Anxiety','Depression','SleepConcerns',
'PTSD','ADD/ADHD'),

sum([PBAS-SupportAssmt/Screening]),
sum([PBAS-EducationHealthCondition]),
sum([PBAS-Relationship]),
sum([PBAS-Behavior]),
sum([PBAS-SupportManagementCare]),
sum([PBAS-LinkCommunityResources]),
sum([PBAS-SupportNavigation]),
sum([PBAS-LinkSpecialty]),
sum([PBAS-SupportMood]),
sum([PBAS-SupportAnxiety]),
sum([PBAS-SupportDepression]),
sum([PBAS-SupportSleepConcerns]),
sum([PBAS-SupportPTSD]),
sum([PBAS-SupportADD/ADHD])
)

In another graph I want to pick only top five value list items (which will dynamically change over the time). Also I want to use my fiscal year dimension instead value list dimension. Can any body help please.

[rittermd]

In your chart you can set a limitation in the Dimension properties that would be based on your first measure or can be a fixed number.