Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
nickedw0
Creator
Creator

Calendar expression to flag Date as occurring in last week of month

The Week() funtion returns the week number in the year. I need to classify transaction dates as occurring in last week of each month.

 

Thanks

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

Perhaps

Week(Date)=Week(MonthEnd(Date)) as IsInLastWeekOfMonth

View solution in original post

1 Reply
hic
Former Employee
Former Employee

Perhaps

Week(Date)=Week(MonthEnd(Date)) as IsInLastWeekOfMonth