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

    Where conditional Load statement



         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)
           40 AS MT_Hours,
           day AS MT_Date
      ) //put in 40 MT_Hours...