Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated dimension for Week starting on Monday

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.

1 Reply
Anonymous
Not applicable
Author

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')