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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Range to Summarize by Quarter

How do I create an expression to take the date column and break it up by quarters. For example 1/1/2016 to 3/31/2016 = 2016Q1

Thank you!

1 Reply
sunny_talwar

May be create it in your master calendar script:

Creating A Master Calendar

LOAD Date,

          Year,

          Month,

          Year&'Q'&Ceil(Month(DateField)/3) as YearQuarter