help :)

[#1]

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

[#2]

Take a look at the following post regarding Master Calendars:

http://community.qlik.com/thread/48693

[MayilVahanan]

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;

[#4]

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

[#5]

John Witherspoon has some great stuff regarding this.  Here is one post he created. 

http://community.qlik.com/message/147535#147535

[#6]

Here is a little example I put together.  Hope it helps!!