topic Re: Calculated dimension for Week starting on Monday in QlikView

Calculated dimension for Week starting on Monday

Thu, 03 Oct 2013 15:14:20 GMT

Hi,

I'm new to qlikview and need assistance with creating a calculated dimension for week starting on monday? Ultimately,need a table that will list a Mondays date, i.e, 9/30/13, 09/23/13 for the specified date range but show totals, averages etc for that entire week, basically a 'Week of [Monday Date] type of date dimension.

Any help would be greatly appreciated!

Brian.

Re: Calculated dimension for Week starting on Monday

Anonymous — Thu, 03 Oct 2013 15:36:31 GMT

Brian,

It is always better to have an actual dimensions rather than calculated, if possible. Speaking of week identified by Monday, you can use weekstart() function:

weekstart(Date)

By deafult, week starts on Monday.

Regards,

Michael

Edit: for your exact presentation, it will be

='Week of ' & date(weekstart(Date),'MM/DD/YY')