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.
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: