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:
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.
use the below code, Hope it will help you.
LET vDateToday = num(today());
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);
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.