Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

MASTER CALENDAR

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:

Immagine3.png


6 Replies
MVP
MVP

Re: MASTER CALENDAR

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.

Arjunarao
Honored Contributor II

Re: MASTER CALENDAR

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);

MVP
MVP

Re: MASTER CALENDAR

Hi,

If you want Master calendar generation script then check below link

Master Calendar Generation Script


Regards,

jagan.

fmazzarelli
Contributor III

Re: MASTER CALENDAR

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 needsImmagine4.png

Arjunarao
Honored Contributor II

Re: MASTER CALENDAR

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.

MVP
MVP

Re: MASTER CALENDAR

Hi,

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

Regards,

Jagan.