topic Re: Where conditional Load statement in QlikView

Where conditional Load statement

Wed, 14 May 2014 18:58:15 GMT

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)

Re: Where conditional Load statement

Wed, 14 May 2014 19:23:43 GMT

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

Re: Where conditional Load statement

Wed, 14 May 2014 19:27:40 GMT

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

Thanks,

Re: Where conditional Load statement

Wed, 14 May 2014 19:38:47 GMT

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

Re: Where conditional Load statement

Wed, 14 May 2014 19:46:18 GMT

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;

Re: Where conditional Load statement

Thu, 15 May 2014 13:25:10 GMT

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

Thanks,

Re: Where conditional Load statement

Wed, 28 May 2014 15:29:26 GMT

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!