topic SV:Re: SV:Re: Calander in QlikView

Calander

Tue, 22 Mar 2011 08:34:51 GMT

Hello!

Can anyone send me the script of a basic calander?

Thanks!

Marco

Calander

Tue, 22 Mar 2011 08:39:34 GMT

Hi,

this is the common example for master calender. and try it with more data instead of one month data. because u learned lot thing in that while using huge data's .

Date:
Load Date as Date,
if(Month(Date)<=3,Month(Date)+9,Month(Date)-3 ) as Month_Code,
year(Date) as Year,
month(Date) as Month,
week(weekname(Date,-13)) as Week,
day(Date) as Day
resident (Tabllename)
where year(Date) > 2007 and week(weekname(Date,-13)) < 53
;

Calander

Tue, 22 Mar 2011 08:40:22 GMT

Hi,

Sorry, this is the basic script for calander .

Calander

Miguel_Angel_Baeyens — Tue, 22 Mar 2011 08:41:23 GMT

Hello Marco,

There is a very good entry in the Wiki about this written by Michael Solomovich (credits to him).

Hope that helps.

AW:Calander

brenner_martina — Tue, 22 Mar 2011 08:49:07 GMT

Hi,

here is a Calender to integrate in your applications.

Calander

Tue, 22 Mar 2011 08:59:53 GMT

First of all thanks for the quick reactions!

But I'm not there yet.

Can you tell me what is going wrong here?

LET Start = floor(YearStart(AddMonths(today(), -12*3)));
LET End = floor(YearEnd(AddMonths(today(), 12)));

LET NumOfDays = End - Start + 1;

Date_src:
LOAD
$(Start) + Rowno() -1 as DateId
AUTOGENERATE $(NumOfDays);

Calendar:
LOAD
DateId, // just in case
date(DateId) as Date, // it will be in format defined in your SET DateFormat=, or in your system format
day(DateID) as Day,
week(DateID) as Week,
month(DateID) as Month, // simple month name; it is dual - numeric and text
dual(month(DateID) & '-' & year(DateID),
year(DateID) & num(month(DateID), '00')) as MonthYear, // Month-Year format, dual
year(DateID) as Year,
weekday(DateID) as Weekday,
'Q' & ceil(month(DateID)/3) as Quarter, // in format Q1, Q2, Q3, Q4
dual('Q' & ceil(month(DateID)/3) & '-' & year(DateID),
year(DateID) & ceil(month(DateID)/3) as QtrYear // Qn-Year, dual
// and whatever else you may want here...

RESIDENT Date_src;
Drop Table Date_src;

LET Start = null();
LET End = null();
LET NumOfDays = null();

SV:Re: Calander

gandalfgray — Tue, 22 Mar 2011 09:09:13 GMT

Just two basic syntax errors, as far as i can see:

You need to add a ")" before "as QtrYear" (to end the dual-function)

You need to replace all "DateID" with "DateId" or vice versa

hth

SV:Re: Calander

Tue, 22 Mar 2011 09:47:57 GMT

Thanks!

I think the script is oke right now.

The next error is DateId filed not found.

Where is this field suppose to be?

SV:Re: Calander

Tue, 22 Mar 2011 09:51:29 GMT

Hi,

This DateID Field must be the field in your table which you want to connect to the calendar.

-Sravan

SV:Re: SV:Re: Calander

gandalfgray — Tue, 22 Mar 2011 09:51:46 GMT

Did you replace all DateId with DateID?

Remember that the field names are case sensitive.

Calander

Tue, 22 Mar 2011 09:56:04 GMT

hi .....meren.

am sending the very simple script for the master calendar. try it once

Calendar:

vDateMin = num(addmonths(date(ToDay()),-27));

LET

vDateMax = Floor(MonthEnd(Today()))

;

TempCalendar:

$(vDateMin)

+ RowNo() - 1 AS DateNumber

Date

($(vDateMin) + RowNo() - 1) AS TempDate

AUTOGENERATE

WHILE

$(vDateMin)+IterNo()-1<= $(vDateMax);

MasterCalendar1:

LOAD

TempDate

CalendarDate

RESIDENT

TempCalendar ORDER BY TempDate ASC;

now we have the "CalendarDate" field contains the calendar data.

regards

A'run'

Re: Calander

Tue, 27 Sep 2011 15:21:16 GMT

Martina ::: Can you tell me how to change the names of month to English?