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

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: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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: 
Not applicable
‎2011-10-26 03:19 PM

Quarters that start on Monday regardless of when the month ends

So I'm currently using this 'Q' & Ceil(Month (TempDate)/3) AS Quarter, to create my quarters.

My requirements are to create quarters that always end on sunday, regardless when the month/quarter actually ends.

For ex: July 2011 and the third quarter began on friday, I would need any transactions for that Friday to be added into the previous quarter and the new quarter to begin on Monday.

Any idea on how to do this, I would need something that would change from year to year, depending on the days.

Thanks QlikCommunity

463 Views
0 Likes
1 Reply
Not applicable
‎2011-10-27 12:47 PM
Author

Hey can anybody help me out with this, thanks

186 Views
0 Likes