Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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')