Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover the Trends Shaping AI in 2026: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calander

Hello!

Can anyone send me the script of a basic calander?

Thanks!

Marco

11 Replies
Not applicable
Author

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



1

WHILE



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



MasterCalendar1:

LOAD



TempDate



AS

CalendarDate

RESIDENT



TempCalendar ORDER BY TempDate ASC;

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

regards

A'run'

Not applicable
Author

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