Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
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
Employee
Employee

Perhaps

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

View solution in original post

1 Reply
hic
Employee
Employee

Perhaps

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