topic charts with daily & weekly data (Rolling Weekly) in QlikView

charts with daily & weekly data (Rolling Weekly)

Wed, 14 Jul 2010 15:53:58 GMT

Hi, I want a chart with daily and weekly data as shown in attached picture.

Columns

Date --- Jan 1st to date

calls duration

please help me out in this by uploading an sample if possible.

Thanks in Advance

charts with daily & weekly data (Rolling Weekly)

Wed, 14 Jul 2010 16:14:33 GMT

You could create a cyclical dimension with 2 fields you create in the load script.

For example if you have StartDate as your daily date. You could:


Load
Date(daystart(StartDate), 'DD-MMM-YY') AS StartDateDayView,
Date(WeekEnd(StartDate), 'DD-MMM-YY') as StartDateWeekView
FROM .......(enter path)
WHERE StartDate > '01-Jan-2010'

charts with daily & weekly data (Rolling Weekly)

Wed, 14 Jul 2010 17:34:36 GMT

Something like this: