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 Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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: 
sislam
Contributor
Contributor
‎2021-06-23 05:28 PM

Splitting Quarter data into trailing 13 months and getting columns for month and year

I am trying to split my quarter data into trailing 13 months and also the years, I am not sure how to do this. I have posted the original logic for the quarter data. So I need the columns 'Monthstart()' and 'Yearstart()' Please help!

 

Original formula for Quarter data column

=SUM(IF(QUARTERSTART(OT_Period)='10/01/2020',OT_Overtime_YTD))

 

The 'OT_Overtime_YTD' is the dollar amounts. Essentially the columns would be. 

 

Region/Location/Employee/Monthstart()/Yearstart()

 

 

541 Views
0 Likes
0 Replies