calendar not right

thabo2g5 — Thu, 24 Aug 2017 07:47:52 GMT

Hi everyone ,

i'm having a problem with my calendar especially january , the 1st start at the bottom (see attached photo)

This is my calendar that i'm using for the calendar please help

MasterCalendar:

LOAD *,

If(WeekDay <5, 1,0) as IsWorkingDay,

If(WeekDay = 5, 1,0) as IsSaturday,

If(WeekDay = 6,1,0) as IsSunday;

LOAD

TempDate AS start_date,

(Year(TempDate)*12+0) +(Month(TempDate)+0) as Cal_Link,

Year(TempDate) AS Year,

Day(TempDate) As Day,

Week(TempDate) as Week,

'Q' & Ceil(Month(TempDate)/3) as Quarter,

Month(TempDate) AS Month,

Weekday(TempDate) AS WeekDay,

inyeartodate(TempDate, maxdate, 0) * -1 AS CurYTDFlag,

inyeartodate(TempDate, maxdate, -1) * -1 AS LastYTDFlag

;

//=== Generate a temp table of dates ===

LOAD

date(mindate + IterNo()) AS TempDate

,maxdate // Used in InYearToDate() above, but not kept

WHILE mindate + IterNo() <= maxdate

;

//=== Get min/max dates from fact table ===/

LOAD

min(Date)-1 as mindate,

max(Date) as maxdate

RESIDENT Incidents;

Dimensions:

weekday

week

expressions:

= ' ' & Day

& chr(10) & chr(10) & concat(Country, chr(10))

Re: calendar not right

petter — Thu, 24 Aug 2017 08:14:02 GMT

This is because Sunday the 1st of 2017 belongs to week number 52 of 2016. Using Week as your dimension will leave the 1st of January as the last row....

Re: calendar not right

thabo2g5 — Thu, 24 Aug 2017 08:20:32 GMT

I found he Solution i was suppose to Set BrokenWeeks=1

Re: calendar not right

thabo2g5 — Thu, 24 Aug 2017 08:22:10 GMT

Thank you for your Reply i found the solution from qlikview help BrokenWeeks ‒ QlikView

topic Re: calendar not right in QlikView

calendar not right

Re: calendar not right

Re: calendar not right

Re: calendar not right