Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Date Range to Summarize by Quarter

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

Community Browser