topic Re: Date in quarter in QlikView

Date in quarter

Fri, 09 Oct 2015 10:06:09 GMT

Hello,

Actually, I need to tranform a string into date for example:

2012_Q1

2012_Q2

2013_Q1

2013_Q2

Until now I only isolated 2012_Q"2" and try to make appear every informations that quarter can show but that way didn't work. Then, do you have a idea to make this string in data?

Regards

Re: Date in quarter

Gysbert_Wassenaar — Fri, 09 Oct 2015 10:14:59 GMT

Perhaps like this: makedate(left(YearQuarter,4),right(YearQuarter,1)*3-2)

Re: Date in quarter

nagaiank — Fri, 09 Oct 2015 10:19:18 GMT

The following script gives

Data:

LOAD *,

Date(MakeDate(Left(YYYY_QN,4),(Right(YYYY_QN,1)-1)*3+1,1)) as QStart;

LOAD * Inline [

YYYY_QN

2012_Q1

2012_Q2

2013_Q1

2013_Q2

];