topic calculate Vacation days in QlikView

calculate Vacation days

Anonymous — Fri, 01 Mar 2013 20:16:41 GMT

i am going to maintain Vacation Maintanace report

in my table I have only present date only

how to calulate leave days

Re: calculate Vacation days

CELAMBARASAN — Fri, 01 Mar 2013 20:43:54 GMT

Create a calendar table with automate script based on the least date and max date.

Example

TempMinDate:

LOAD

Min(Date) AS MinDate

RESIDENT TableName;

LET vDateMin = FieldValue('MinDate', 1);

LET vTodayNum = Num(Today());

DROP TABLE TempMinDate;

SalesDates:

LOAD

($(vDateMin) + (RecNo()) - 1) AS Date,

RecNo() AS DateRecNo

AUTOGENERATE ($(vTodayNum) - $(vDateMin) + 1);

Re: calculate Vacation days

Anonymous — Fri, 01 Mar 2013 20:49:56 GMT

I Have Table like this

ID PresentDATE

1 12/2/2013

2 12/2/2013

1 13/2/2013

1 14/2/2013

2 15/2/2013

i need to calculate leave days

Re: calculate Vacation days

eddysanchez — Fri, 01 Mar 2013 21:37:44 GMT

with the next code

TempMinDate:

LOAD

Min(PresentDATE) AS MinDate

RESIDENT TableName;

LET vDateMin = FieldValue('MinDate', 1);

LET vTodayNum = Num(Today());

DROP TABLE TempMinDate;

SalesDates:

LOAD

num($(vDateMin) + (RecNo()) - 1) AS DATE

AUTOGENERATE ($(vTodayNum) - $(vDateMin) + 1);

left join (SalesDates)

LOAD Distinct ID

Resident TableName;

You have the table SalesDate with all dates for each ID

and you can show or sum (depends or your requeriment) in your layout the leave days