Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

App Development

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
nickedw0
Creator
Creator
‎2022-02-16 11:59 AM

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

142 Views
0 Likes
1 Solution

Accepted Solutions
hic
Employee
Employee
‎2022-02-16 12:16 PM

Perhaps

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

View solution in original post

130 Views
1 Reply
hic
Employee
Employee
‎2022-02-16 12:16 PM

Perhaps

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

131 Views