topic Calendar Question in QlikView

Calendar Question

Wed, 01 Jul 2009 02:58:59 GMT

I have an application that uses a Master calendar. My company ran an early month end on Friday (6/26). That means that all transactions from 6/27 through 6/30 will have an Accounting Date of July. Any ideas on how I can incorporate this into my Master Calendar which is based on Today's date without disturbing the Calendar functions already created?

Calendar Question

prieper — Wed, 01 Jul 2009 03:03:08 GMT

Hi,

why not splitting into two fields: one with transaction-date, the other one with accounting-date or -month and then link your Master-calendar to one of them

HTH

Peter

Calendar Question

Anonymous — Wed, 01 Jul 2009 03:48:08 GMT

I recommend to add a field "Accounting Month" to the master calendar, and define by the last Friday of the calendar month. Foe example:


JOIN (Calendar) LOAD DISTINCT
 MonthYear,
 max(DateID) as LastFriday
RESIDENT Calendar
where Weekday=4
GROUP BY MonthYear;
//
JOIN (Calendar) LOAD DISTINCT
 DateID,
 date(monthstart(if(DateID<=LastFriday, DateID, DateID+7)),'MMM-YY') as AccountingMonth
RESIDENT Calendar;