topic Generate Broadcast Calendar in QlikView

Generate Broadcast Calendar

Thu, 30 Jul 2009 02:11:37 GMT

I am currently in the process of building a QV application for a broadcasting company. All broadcasting companies (radio, tv, etc) uses a standard broadcast calendar. Has it's own begin and end dates for month, quarter and year.

Is there any one having a logic to generate broadcast calendar dates for a given year? I would like to use the logic instead of reinventing the weel.

Thanks,

Satheesh

Generate Broadcast Calendar

Anonymous — Thu, 30 Jul 2009 03:49:30 GMT

Satheesh,
I don't know what the boradcast calendar is... See my post on Wiki How to Create a Calendar, maybe it can help.

Generate Broadcast Calendar

Thu, 30 Jul 2009 21:02:25 GMT

Mike,

All Radio stations and TV stations follow a standard calendar which is different from general calendar. For e.g. Broadcast calendar for 2009 begins 12/31/08 and ends 12/26/09.

JAN = 12/31/08 - 1/27/09

FEB = 1/28/09 - 2/24/09

MAR = 2/25/09 - 3/30/09 etc.

You can see and print the calendar through the software 'BCal.exe' which is available fee in the web. You can google for 'Standard Broadcast Calendar' to see calendars for some years.

My issue is to build a logic in QV to report on Week, Month, Quarter, etc. If you have any idea please help me.

Satheesh

Generate Broadcast Calendar

Thu, 30 Jul 2009 21:32:16 GMT

I would suggest that you create a Broadcast Dates table and put your broadcast information in there.

We use a Dates table that contains a record for every date. In that record, we have a standard date field, a week/year field, a quarter field, etc. Once you link your dataset to this Broadcast Dates table, you will be able to use any of those fields.

EDIT: Here's a quick sample:

Key Date Month Year Quarter Week
1 12/31/2008 1 2009 1 012009
2 1/1/2009 1 2009 1 012009
3 1/2/2009 1 2009 1 012009

Generate Broadcast Calendar

Anonymous — Thu, 30 Jul 2009 22:22:10 GMT

Satheesh,
This is what I googled out:
"A standard broadcast week starts on Monday and ends on Sunday. The standard broadcast month ends on the last Sunday of the calendar month. "

Week in QV by default starts on Monday, so there is nothing special to do. If you define week by its start date, it will be
weekstart(DateId)) as Week
You can define month and year this way:
date(monthstart(weekstart(DateId)), 'MMM-YY') as Month,
year(weekstart(DateId)) as Year

Generate Broadcast Calendar

Fri, 31 Jul 2009 23:45:14 GMT

I have done the same using the excel and loaded into qvw. I was wondering for any possible automation without maintaining this sheet/table.

Thanks anyway.

Generate Broadcast Calendar

Fri, 31 Jul 2009 23:46:52 GMT

Thanks Michael. I will look into it.