6 Replies Latest reply: Mar 29, 2017 5:14 AM by Kieron O'Keeffe RSS

    problem with wildmatch or else save statement

    Kieron O'Keeffe

      Hi all,

       

      I am trying to take a resident load of the following statement from a Qlikview app and store it out to a new QVD that will be used in a Qliksense app, but it keeps failing at the save stage. Can anyone tell me where I'm going wrong please ?

       

      T_Kick:
      LOAD
      kicktrn.int_code,
      [Fat Class - Short],
      [Grade code - Short],
      kicktrn
      .cat_code,
      kicktrn
      .Category_sorted,
      killtrn.date_kick,
      YearWeek,
      kicktrn
      .eartag as [Kick Count]
         resident kicktrn

      where WildMatch(kicktrn.int_code,'TE*')
      ;


      store T_Kick into \\idmgraqvshub12\Qlik_Sense_Data\T\T_Kick.qvd;

       

      Thanks,

       

      Kieron