Qlikview: Broadcast Calendar
I had to create a broadcast calendar month in Qlikview .
Quick explanation from wikipedia: “The broadcast calendar is a standardized calendar used primarily for the planning and purchase of radio and television programs and advertising.[1] ”
Broadcast week starts on Monday and ends on Sunday. Start of the month is the first Monday of the week that 1st day of the standard calendar month belongs.
i.e. Broadcast month for
- June is May28 ~ June 24, 2012
- July is June 25 ~ July 29, 2012
This script worked very well in my document.
date(MonthStart(WeekEnd(DateId)), ‘MMM-YY’) as BroadcastMonthYear
Simple.
Hyunku's Blog 
No trackbacks yet.