Where conditional Load statement

[#1]

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)

[#2]

if you are trying to achieve the above, you have to look for "group by" in scripting with a resident table as filter table.

[#3]

Can you describe that in more detail, I'm new to qlikview?

Thanks,

[#4]

can you please paste  the complete script or QVW file , so that I can send you in detail.

[#5]

GroupTable:

Load

[propername],

[Group_Name],

sum(hour) as SummedHours

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

//Change the QVD file if this is not right one

group by propername,[Group_Name];

Filtertable:

Load

[propername] & [Group_Name] as f_propernameandGroup_Name

Resident GroupTable

where SummedHours > 40

drop table GroupTable;

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)

where exists (f_propernameandGroup_Name,[propername] & [Group_Name]);

drop table Filtertable;

[#6]

I will try this and let you know, I got busy doing other things.

Thanks,

[#7]

Hello,

    I went another route:

({1<Act_Group_Name = p(Act_Group_Name)>}[NT_Hours])

was used with a  table that logged active users (we do have some turnover) and a loop to calculate NT_Hours which does not really matter.

I actually really appreciate how this equation works and did not know it was possible; found it in the qlikview book.

Thanks!