topic Re: create date using quarter and year in QlikView

create date using quarter and year

Tue, 30 Jun 2015 04:52:55 GMT

can we create date from year and quarter field

Re: create date using quarter and year

vivek_niti — Tue, 30 Jun 2015 04:54:28 GMT

Please share sample data.

Re: create date using quarter and year

arulsettu — Tue, 30 Jun 2015 04:57:14 GMT

try like this

makedate(year,quarter) as date

Re: create date using quarter and year

vivek_niti — Tue, 30 Jun 2015 05:00:17 GMT

The makedate function only accepts year, month and day as parameters.

Re: create date using quarter and year

avinashelite — Tue, 30 Jun 2015 05:03:32 GMT

Hi Shweta,

Build a custom calendar and like the Quarter and year ...that the easiest way to generate dates

Re: create date using quarter and year

Tue, 30 Jun 2015 05:05:51 GMT

how?

Re: create date using quarter and year

Tue, 30 Jun 2015 05:05:59 GMT

Derive Month from Quarter And use makedate function with year and derived month,

If quarter = Q1, Month = Jan or Feb Or Mar Like this,

and Makedate(year, Month) As Date

Faisal

Re: create date using quarter and year

jonathandienst — Tue, 30 Jun 2015 05:07:30 GMT

Assuming quarter is a number between 1 and 4:

=MakeDate(year, (quarter - 1) * 3 + 1)

Re: create date using quarter and year

Tue, 30 Jun 2015 05:09:28 GMT

pfa

Re: create date using quarter and year

vivek_niti — Tue, 30 Jun 2015 05:16:26 GMT

Try this code

tab1:

LOAD * INLINE [

Year, Quarter

2015, 1

2015, 2

2015, 3

2015, 4

];

tab2:

LOAD *,

Date(Makedate(Year,Month),'DD-MM-YYYY') AS Date;

LOAD Year,

Quarter,

Pick(Match(Quarter,1,2,3,4),1,4,6,10) AS Month

RESIDENT tab1;

DROP TABLE tab1;

Re: create date using quarter and year

Tue, 30 Jun 2015 05:30:33 GMT

this give wrong result pfa

Re: create date using quarter and year

jagan — Tue, 30 Jun 2015 05:33:18 GMT

Hi,

Try like this

LOAD *,

MakeDate(Year, Quarter*3) AS Date

INLINE [

Year, Quarter

2015, 1

2015, 2

2015, 3

2015, 4

];

Regards,

Jagan.

Re: create date using quarter and year

MarcoWedel — Tue, 30 Jun 2015 05:38:44 GMT

Looks correct

Which result did you expect?

Regards

Marco

Re: create date using quarter and year

jonathandienst — Tue, 30 Jun 2015 05:43:56 GMT

Well its the correct result if you want the first day of each quarter. So what date do you want?

Re: create date using quarter and year

settu_periasamy — Tue, 30 Jun 2015 05:47:53 GMT

Hi,

check this link by jagan

Fiscal and Standard Calendar generation

Re: create date using quarter and year

Tue, 30 Jun 2015 05:59:34 GMT

I want all the month

Re: create date using quarter and year

aveeeeeee7en — Tue, 30 Jun 2015 06:13:37 GMT

Hi Try this Script:

MasterCalendar:
LOAD
Date AS CreatedDate,
Month(Date) AS CalendarMonth,
Year(Date) AS CalendarYear,
'Q'&ceil(Month(Date)/3) AS Quarters,
Month(Date) & '-' & Year(Date) AS CalendarMonthAndYear;

LOAD
Date(makedate(2015,1,1)+recno()-1,'DD/MM/YYYY') as Date
Autogenerate makedate(2015,12,31) - makedate(2015,1,1) + 1;

Hope that helps.

Regards

Av7en

Re: create date using quarter and year

qlikviewwizard — Tue, 30 Jun 2015 06:38:49 GMT

Hi shweta08,

Please try with jagan or arulsettu 's advise.

Enclosed the file for your reference.

YrQtr:
LOAD *,
MakeDate(Year, Quarter*3) AS Date
INLINE [
    Year, Quarter
    2015, 1
    2015, 2
    2015, 3
    2015, 4
];

Re: create date using quarter and year

jagan — Tue, 30 Jun 2015 06:39:53 GMT

Hi Swetha,

Try this script below

LOAD *,

MakeDate(Year, Quarter*3) AS Date,

SubField(Quarter*3 & '/' & (Quarter*3 - 1) & '/' & (Quarter*3 - 2), '/') AS Month

INLINE [

Year, Quarter

2015, 1

2015, 2

2015, 3

2015, 4

];

Regards,

Jagan.