MASTER CALENDAR

[fmazzarelli]

Hi

I've just finished to watch video about MASTER CALENDAR.

I replied all but my request is different.

Could I insert an object calendar

From date .... 01/07/2015

To date ........ 20/07/2015

And another date

Overdue date: 15/7/2015.

My needs are:

have a report that will show

a. bills before the due date

b. bills after the due rate.

The due rate could be:

[jagan]

Hi, If you attach the sample data and your expected it would be easier to understand and provide the solution. Go through the below link it helps you in getting the answers quickly. https://community.qlik.com/docs/DOC-7538 Hope this helps you. Regards, Jagan.

[qlikviewwizard]

Hi fmazzarelli

use the below code, Hope it will help you.

LET vDateMin=num(makedate(2015,07,01));

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

LET vDateToday = num(today());

Calender:

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

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

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

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

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

[jagan]

Hi,

If you want Master calendar generation script then check below link

Master Calendar Generation Script

Regards,

jagan.

[fmazzarelli]

hi jagan mohan,

you are very kind but perhaps I am not able to explain my needs or understand your directions.

I attached again my needs

[qlikviewwizard]

Hi fmazzarelli

Generally we use the above type calendars. I hope everyone use the more or less same type.

Post the exact requirement. SO that our folks will give the better solution.

[jagan]

Hi,

Attach some sample data and your expected output so that it would be easier to understand and provide the solution.

Regards,

Jagan.