topic makedate from 2018Q1 in QlikView

makedate from 2018Q1

yipchunyu — Wed, 28 Nov 2018 09:34:58 GMT

Very simple question, any function to convert 2018Q1, 2018Q2 as the date e.g. YYYY/MM/DD - 2018/1/1, 2018/4/1 ...

Re: makedate from 2018Q1

tresB — Wed, 28 Nov 2018 09:51:45 GMT

This could be one way.

Re: makedate from 2018Q1

jfkinspari — Wed, 28 Nov 2018 09:56:07 GMT

Sure, number of ways, bot not explicit function to interpret Quarters as in e.g. Q1

Date:
LOAD
Quarter,
MakeDate(Left(Quarter, 4), (right(Quarter,1)*3)-2) As Date;
LOAD * Inline [
Quarter
2018Q1
2018Q2
2018Q3
2018Q4
];

Re: makedate from 2018Q1

lse — Wed, 28 Nov 2018 10:00:32 GMT

I'd do it in the load script with something like this:

Load
*,
QuarterStart(MakeDate(SubField(Quarter,'Q', 1), SubField(Quarter,'Q', 2)*3)) as [DateInQ Option 1],
MakeDate(SubField(Quarter, 'Q', 1), SubField(Quarter, 'Q', 2)*3-2) as [DateInQ Option 2];
Load
Upper(Quarter) as Quarter;
Load
*
Inline
[Quarter
2018Q1
2018Q2
2018Q3
2018Q4
2019Q1];