Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Champion III
Champion III

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