6 Replies Latest reply: Jun 19, 2012 6:35 AM by Danielle Sayed RSS

    Using the intersection set operator in a chart expression

      Hello,

       

      I am having trouble getting the intersection set operator to work in an expression for a bar chart. I want to count the people who belong to both set operands but the expression is returning no data. In the raw data there are people who belong to both sets. The user needs to select the term of entry for the chart conditions to be fulfilled.

       

      Advice would be appreciated.

       

      Here is the expression I'm currently using;

       

      count

      ({$<TermofEntry = {$(= only (TermofEntry))},

      LevelCode = {'PGR'},

      ExtractType = {1},

      YearofProgram = {'1'},

      RegStatusCode = {'RE','RS'},

      InstanceTerm = {$(= only (TermofEntry))},

      CollegeCode = {'AF', 'SF', 'HF'},

      ResearchDoctMastInd = {R}, ModeofStudy = {'FT'}

      > *

      <
      TermofEntry = {$(= only (TermofEntry))},

      LevelCode = {'PGR'},

      ExtractType = {1},

      YearofProgram = {'2'},

      RegStatusCode = {'RE', 'RS'},

      InstanceTerm = {$(= only (TermofEntry)+ 100)},

      CollegeCode = {'AF', 'SF', 'HF'},

      ResearchDoctMastInd = {'R'}, ModeofStudy = {'FT'}

      >}
      pidm)