Multiple calendar Types in the same Master Calendar Table

bruno_m_santos — Wed, 24 Apr 2013 14:26:52 GMT

Hello to everybody.

I’ve created a new discussion because the old one had problems.

I have a question. What is the difference between the following two expressions? I thought in my "inexperience" that the values should be equal but they are not.

I need your help to understand what is happening.

Expression1

=Sum({$<MonthID = {"<=$(=Max(MonthID))"},

CalendarType={"Fiscal"},

Date = {"<=$(=Max(Date))"},

Year = {$(=Max(Year))},

Week = ,

Quarter = ,

Period = ,

[Period (#)] = ,

Month = >}[#Turnover EUR])

Expression2:

=Sum({$<MonthID = {"<=$(=Max(MonthID))"},

Date = {"<=$(=Max(Date))"},

Year = {$(=Max(Year))},

Week = ,

Quarter = ,

Period = ,

[Period (#)] = ,

Month = >*<CalendarType={"Fiscal"}>}[#Turnover EUR])

The use of the "*" in the second expression intends to intersect with the lines of the "calendar table", in which CalendarType= "Fiscal".

My first expression doesn't return the correct data, because the Max(MonthID) for same year in calendartype="Fiscal" isn't same of other calendar type (eg:
Gregorian).

I've three calendars in the same table, with a identifier which is CalendarType.

My intention is to pass the calendar type as an variable, but for now i'm only testing values.

I 'll apreciate very much your help.

Bruno

topic Multiple calendar Types in the same Master Calendar Table in QlikView

Multiple calendar Types in the same Master Calendar Table