2 Replies Latest reply: Jul 5, 2016 6:42 PM by Ian Tye RSS

    Intervalmatch problems

    Ian Tye

      Hi,

       

      I am moving my load scripts from Qlikview to Qlik Sense and have encountered an error. Would someone be able to assist?

       

      The section of load script is;

       

      AgeGroups:
      LOAD * INLINE [
          Bottom, Top, AgeGroup
      0, 0.99, 0
      1, 4.99, 1-4
      5, 9.99, 5-9
      10, 14.99, 10-14
      15, 19.99, 15-19
      20, 24.99, 20-24
      25, 29.99, 25-29
      30, 34.99, 30-34
      35, 39.99, 35-39
      40, 44.99, 40-44
      45, 49.99, 45-49
      50, 54.99, 50-54
      55, 59.99, 55-59
      60, 64.99, 60-64
      65, 69.99, 65-69
      70, 74.99, 70-74
      75, 79.99, 75-79
      80, 84.99, 80-84
      85, 200, 85+
      ];

       

      IntervalMatch(Patient_age)
      left join(AgeGroups)

      load Bottom, Top Resident AgeGroups;

      drop fields Bottom, Top;

       

      I am attempting to find an age group for each Patient_age. The Patient_age field is loaded prior to the execution of this script.

       

      I get the following error;

      Field not found: IntervalMatch(Patient_age) left join(AgeGroups) load Bottom, Top Resident AgeGroups

       

      The script worked fine in Qlikview.

       

      Any help would be much appreciated.

       

      Cheers

      Ian

        • Re: Intervalmatch problems
          Onno van Knotsenburg

          Are you maybe using a QUALIFY statement earlier in your script, before you load Patient_age, that you forgot to close with an UNQUALIFY *; ? During training I often notice participants forgetting the star.

           

          If that is not the case, could you show us the line of script right before you load that AgeGroups Inline table and the part in which you load Patient_age? Maybe it is just a silly typo or a missing ;