Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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')