4 Replies Latest reply: Oct 25, 2011 9:33 AM by Claudia Zwick RSS

    Why is this an invalid expression?


      Hi, I'm just getting into QlikView and trying to learn.....  I cannot see the error in the following expression, even thought I know it must be simple.    Suggestions?     Thanks,        Tee

      LOAD count(SURGEON) as cases, 
           FACILITY_NAME, 
           Year, 
           Month
      From
      D:\Documents\QlikView\t_SampleData.xlsx
      (ooxml, embedded labels)
      where FACILITY_NAME like '*South' and Year = '2011' 
      Group by  SURGEON,Month;