topic Re: Making a date from Quarter and Year in QlikView

Making a date from Quarter and Year

Thu, 18 Sep 2014 12:18:06 GMT

Hi,

Another date related question from me, hope someone can help.

In my data I have two columns: Quarter and Year. How can I make a date from them where the date will be the last month of each quarter?

For example Q4 2014 would be 01.12.2014, Q3 2014 would be 01.09.2014.

Many thanks

Thu, 18 Sep 2014 12:19:53 GMT

try like this

makedate(1999) returns 1999-01-01

makedate(99) returns 0099-01-01

makedate(1992,12) returns 1992-12-01

makedate(1999,2,14) returns 1999-02-14

tresB — Thu, 18 Sep 2014 12:21:57 GMT

=MakeDate(Mid(YourQuarter,4), Mid(YourQuarter,2,1)*3)

Anonymous — Thu, 18 Sep 2014 12:25:27 GMT

you can use (monthstart(quarterend(yourquarteryeardate))

if you have two fields year and quarter (2 characters) use:

makedate(year, monthstart(right(Quarterstring,1)*3))

Thu, 18 Sep 2014 12:29:23 GMT

Or try

makedate(YearNo,ceil(QtrNo*3)-2)

MK_QSL — Thu, 18 Sep 2014 12:54:06 GMT

=Date(MakeDate(Right('Q4 2014',4),Mid('Q4 2014',2,1)*3),'DD.MM.YYYY')

Thu, 18 Sep 2014 15:46:14 GMT

Thank you all!