1 Reply Latest reply: Sep 8, 2017 3:02 PM by Mark Ritter RSS

    Choose top five values in Measure formulas (QlikSense)

    Saima SM

      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.