6 Replies Latest reply: May 28, 2014 11:29 AM by Laurea Diaz RSS

    Where conditional Load statement


      Hello,

       

         I am using qlickview for a time tracking tool reporter. If a person has not entered their time yet, but their manager wants to see their team's enties the data would not appear (because no time is entered).

       

         I am trying to load a field if the time entered is < 40 hours to show the manager who is missing time. I am a beginner and anything helps.

       

          Here is what I tried:

       

      WHERE ((SUM(TOTAL< [propername],[Group_Name]>hour)) < '40')       //if not 40 hours for person in dept

      LEFT JOIN (Missing_Time)
      LOAD
           40 AS MT_Hours,
           day AS MT_Date
      ) //put in 40 MT_Hours...

      FROM
      [..\QVD\ProjectOpen\im_hours.qvd]
      (qvd)