# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Contributor III

## Date field to Quarters

Hi Guys

How would I include in my Qlikview doc the option to select date in Quarters

My date field is DECDDT

i.e. Q1, Q2, Q3, Q4

How would i do this in my script?

1 Solution

Accepted Solutions
MVP

## Re: Date field to Quarters

Try like:

Dual('Q' & ceil(Month(DECDDT)/3) & ' ' & Year(DECDDT), Year(DECDDT)*10+ ceil(Month(DECDDT)/3)) AS Quarter,

10 Replies
MVP

## Re: Date field to Quarters

What is "DECDDT" ? Could you explain your date field data format?

## Re: Date field to Quarters

Just an example of how you can accomplish this in your Load Script:

:

Dual('Q' & ceil(Month(DECDDT)/3), ceil(Month(DECDDT)/3)) AS Quarter,

:

For further information: almost every MasterCalendar example script available in this Community shows you how to calculate the Quarter value from a date field. In different ways.

## Re: Date field to Quarters

Or simply

'Q' & Ceil(Month(DECDDT)/3) as Quarter

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Contributor III

## Re: Date field to Quarters

Hi Peter

Thankyou that helped tremendously, however it has grouped the years in together

q1= Jan 2016 feb 2016 mar 2016

Jan 2017 feb2017  mar 2017

q2= apr 2016 may 2016  jun 2016

apr 2017 may 2017 jun2017

I want the quarters to year specific, how can this be done?

## Re: Date field to Quarters

You mean to say, You have only 2016 and 2017 Data. Is that is correct, Although you can use same as perter and my suggestion to the en-count. If not, Please share sample data to look

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Contributor III

## Re: Date field to Quarters

yes Anil so i would like Q1 2016 then Q2 2016 and so on and so on

Honored Contributor III

## Re: Date field to Quarters

Hi Aaron,

QuarterName('01-01-2017') ->  gen-mar 2017

Regards,

Antonio

## Re: Date field to Quarters

May be helps

quartername ‒ QlikView

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP

## Re: Date field to Quarters

Try like:

Dual('Q' & ceil(Month(DECDDT)/3) & ' ' & Year(DECDDT), Year(DECDDT)*10+ ceil(Month(DECDDT)/3)) AS Quarter,