Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sislam
Contributor
Contributor

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()

 

 

0 Replies