# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for
Did you mean:
Creator 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

Try like:

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

10 Replies
MVP

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

Partner

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.

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)
Creator III
Author

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?

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)
Creator III
Author

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

Master III

Hi Aaron,

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

Regards,

Antonio

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

Try like:

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