Calendar

kevbrown — Thu, 23 Jun 2016 12:43:34 GMT

I have 2 dates in the same table that I want to link to my calendar, can I do this? I have a leavers table and I have start date and leave date. In the front end I would like to able to select a date and see how many people left on this date as well as started

Do I need to change my calendar?

LET vDateMin=num(makedate(2011,01,01));

LET vDateMax=floor(monthend(today()));

LET vDateToday = num(today());

Calender:

LOAD Distinct Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY') AS Date,

Day(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Day,

month(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Month,

year(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Year,

monthname(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Monthname,

Week(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Week

AutoGenerate 1 While $(vDateMin) + IterNo() - 1 <=$(vDateMax);

Re: Calendar

trdandamudi — Thu, 23 Jun 2016 12:45:50 GMT

The below link should help you to resolve your issue...

Two different Dates

Re: Calendar

MK_QSL — Thu, 23 Jun 2016 12:46:00 GMT

Two different Dates

topic Re: Calendar in QlikView

Calendar

Re: Calendar

Re: Calendar