13 Replies Latest reply: May 3, 2016 11:30 AM by Sunny Talwar RSS

    Where clause with qualified fields is not working

    Prabhakar Vammi

       

      I am getting the following error:  Error: Field not found - <Date>

       

      QUALIFY *;
        GeoLocColSum:
       
      LOAD REGION
      ,
           Floor(DATE) as Date
      ,
        "TOTAL_REQUESTS"
      ,
        "PASSED_REQUESTS"
      ,
        "FAILED_REQUESTS"
      ,
        ISMAXDATE
       
       
      Resident GeoLocColSumTemp Where Date>$(vMaxDate)
      ;

      It is showing the same error even if I use Where GeoLocColSum.Date>$(vMaxDate);

       

      I think this is because of Qualify.

       

      Your help is appreciated.