topic Re: help :) in QlikView

help :)

Tue, 06 Nov 2012 19:12:40 GMT

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

Re: help :)

Tue, 06 Nov 2012 20:22:48 GMT

Take a look at the following post regarding Master Calendars:

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

Re: help :)

MayilVahanan — Tue, 06 Nov 2012 20:34:44 GMT

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;

Re: help :)

Tue, 06 Nov 2012 20:36:30 GMT

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

Re: help :)

Tue, 06 Nov 2012 21:00:12 GMT

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

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

Re: help :)

Tue, 06 Nov 2012 21:55:01 GMT

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