How to use master calender

[Anonymous]

Hi

I have date field named "time_stamp" , i need to link the master calender with the time_stamp in my query , basically i want all the date types based on the "time_stamp" in my query , How do i do that.

i am following the master calender given @ http://community.qlik.com/media/p/113268.aspx

Please Help

Thanks

[#2]

Hello Ramaya........

Plz read the reference manual, there you will get process to create the calender and master calender.

Its available on forum as well on Qliktech website.

Calendar:
LOAD DISTINCT
TimeStamp,
Year(TimeStamp) as Year,
Month(TimeStamp) as Month,
Date(Monthstart(TimeStamp), 'MMM-YYYY') as YearMonth,
'Q' & Ceil(Month(TimeStamp)/3) as Quarter,
Dual(Year(TimeStamp) & '-Q' & Ceil(Month(TimeStamp)/3), Year(TimeStamp) & Ceil(Month(TimeStamp)/3)) as YearQtr,
Week(TimeStamp) as Week

[Anonymous]

Thank you for the reply Ashwin , i need all the dates types in the calender assined to the my field time stamp , i have doenloaded the master calender qlikview application from the forum , but where do i enter that all calender values should be from the time_stamp value in the code.

Could you please send me the link of teh reference manual.