topic Re: Date field to Quarters in QlikView

Date field to Quarters

aaronnayan — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Date field to Quarters

tresB — Mon, 12 Jun 2017 09:15:01 GMT

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

Re: Date field to Quarters

Peter_Cammaert — Mon, 12 Jun 2017 09:24:54 GMT

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

Anil_Babu_Samineni — Mon, 12 Jun 2017 09:58:58 GMT

Or simply

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

Re: Date field to Quarters

aaronnayan — Mon, 12 Jun 2017 10:00:58 GMT

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

Anil_Babu_Samineni — Mon, 12 Jun 2017 10:08:57 GMT

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

Re: Date field to Quarters

aaronnayan — Mon, 12 Jun 2017 10:10:47 GMT

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

Re: Date field to Quarters

antoniotiman — Mon, 12 Jun 2017 10:11:38 GMT

Hi Aaron,

what about QuarterName() function ?

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

Regards,

Antonio

Re: Date field to Quarters

Anil_Babu_Samineni — Mon, 12 Jun 2017 10:17:09 GMT

May be helps

quartername ‒ QlikView

Re: Date field to Quarters

tresB — Mon, 12 Jun 2017 10:18:40 GMT

Try like:

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

Re: Date field to Quarters

Peter_Cammaert — Mon, 12 Jun 2017 10:23:48 GMT

Simpeler, this one?

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

QuarterStart(DECDDT)) AS Quarter,