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.

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

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



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





0 Replies