create date using quarter and year

[#1]

can we create date from year and quarter field

[#2]

this give wrong result pfa

[jagan]

Hi,

Try like this

LOAD *,

MakeDate(Year, Quarter*3) AS Date

INLINE [

    Year, Quarter

    2015, 1

    2015, 2

    2015, 3

    2015, 4

];

Regards,

Jagan.

[MarcoWedel]

Looks correct

Which result did you expect?

Regards

Marco

[jonathandienst]

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

[settu_periasamy]

Hi,

check this link by jagan

Fiscal and Standard Calendar generation

[#7]

I want all the month

[aveeeeeee7en]

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

[qlikviewwizard]

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
];

[jagan · Accepted solution]

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.