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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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!

Labels (1)
1 Reply
sunny_talwar
MVP
MVP

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