Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to qv community and qv:)can you help me ?
I have to make application where i count employee working in company , at choosen month , but the problem is at my company we have short time and everybody start and end work different time.
I have no idea how to connect calendar (and what type of calendar) with employee table
I have attach exal file with daprtment ID, eployee title and start and end date
I hope u can find solution
Take a look at the following post regarding Master Calendars:
HI
Dept:
LOAD Department_ID,
Position_Title.TITLE As DeptTitle,
Date(ACTUAL_START_DATE,'DD/MM/YYYY') as StartDate,
Date(ACTUAL_END_DATE,'DD/MM/YYYY') as EndDate
FROM
CH01_20121106_131307.xls
(biff, embedded labels, table is Sheet1$);
Let vNoofRows = NoOfRows('Dept');
Let vStartDate = Num(Peek('StartDate',0,'Dept'));
Let vEndDate = Num(Peek('EndDate',$(vNoofRows)-1,'Dept'));
Generate:
LOAD Date($(vStartDate) + IterNo()) AS Date
AutoGenerate 1
While ($(vStartDate) + IterNo()) <= $(vEndDate);
LOAD Month(Date)*1 AS MonthKey, Month(Date) as Month,Year(Date) AS Year,Date,Day(Date) AS Day,Num(Date) as DateNum
Resident Generate;
hi,
thank you very much for your response
the problem is that in my mastercalendar i rename tempdate with Actual_start_date and when I choose for example march it show me only employee that start theirs job in for example march but I have to count as well people who start in fabruary and finish in March and people who start in Febuary and finish in April
and the bigger problem is in third case , I have no idea how to connect it
John Witherspoon has some great stuff regarding this. Here is one post he created.
Here is a little example I put together. Hope it helps!!