topic Re: Convert date to quarterly variant in QlikView

Convert date to quarterly variant

Tue, 25 Jul 2017 21:01:38 GMT

Hello,

I need some help converting regular date values (MM/DD/YYYY) into a quaterly equivalent, such that for any date in columnA, a new date in columnB is generated whose month can only be 3,6,9,or 12. This needs to be done in the load script

For example:

columnA	columnB
1/13/2016	3/1/2016
5/29/2016	6/1/2016
11/30/2017	12/1/2017
12/31/2017	12/1/2017
9/18/2018	9/1/2018

Any advice is greatly appreciated!

Regards,

Kyle Platte

Re: Convert date to quarterly variant

sunny_talwar — Wed, 26 Jul 2017 00:53:58 GMT

Do you want to go to next quarter or stay in the current one for columnB?

Try on of these

QuarterStart(columnA) as columnB1

QuarterStart(columnA, 1) as columnB2

Re: Convert date to quarterly variant

settu_periasamy — Wed, 26 Jul 2017 01:43:52 GMT

Like this..

LOAD columnA,

MonthStart(QuarterEnd(columnA)) as columnA1,

columnB

FROM

[https://community.qlik.com/thread/268948]

(html, codepage is 1252, embedded labels, table is @1);

Re: Convert date to quarterly variant

Wed, 26 Jul 2017 15:56:19 GMT

Thanks, Settu!

Exactly what I needed.

Regards,

Kyle