Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Choose top five values in Measure formulas (QlikSense)

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.


1 Reply
rittermd
Honored Contributor

Re: Choose top five values in Measure formulas (QlikSense)

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.