same period for 3 date feild

Anonymous — Wed, 14 Aug 2013 08:33:13 GMT

hi,

i have 3 date feild with 3 different meaning.

i want to make one feild for : year,querter,month for the 3 feild.

how to do it ?

thanks'

yarin.

Re: same period for 3 date feild

Gysbert_Wassenaar — Wed, 14 Aug 2013 08:58:03 GMT

See this blog post: The Master Calendar

And this discussion

Re: same period for 3 date feild

er_mohit — Wed, 14 Aug 2013 09:06:41 GMT

you have to make a master calendar and putting same Name field for date so that, it automatically linked with it

Try this

// Calender

LET vDateMin = Num(MakeDate(2008,1,1));

LET vDateMax = Floor(DayEnd(Today()));

LET vDateToday = Num(Today());

TempCalendar:

LOAD

$(vDateMin) + RowNo() - 1 AS DateNumber,

Date($(vDateMin) + RowNo() - 1) AS TempDate

AUTOGENERATE 1

WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);

Calendar:

LOAD

Date(TempDate,'DD-MM-YYYY' ) AS CalendarDate,

// Standard Date Objects

Day(TempDate) AS CalendarDayOfMonth,

WeekDay(TempDate) AS CalendarDayName,

num(WeekDay(Today()))as ppp,

Week(TempDate) AS CalendarWeekOfYear,

Month(TempDate) AS CalendarMonthName,

'Q' & Ceil(Month(TempDate)/3) AS CalendarQuarter,

'W' & Ceil(Week(TempDate)/8) as Fiscalweek,

Date(Date#('Mar Week 5','MMM WWW D'),'DD/MM/YYYY') AS Sunday,

Year(TempDate) AS CalendarYear,

Dual(Year(TempDate) & '-Q' & Ceil(Month(TempDate)/3), Year(TempDate) & Ceil(Month(TempDate)/3)) as YearQtr,

'FY' & Right( Year(TempDate),2) as YearQtrfy,

// Calendar Date Names

WeekName(TempDate) as CalendarWeekNumberAndYear,

MonthName(TempDate) as CalendarMonthAndYear,

QuarterName(TempDate) as CalendarQuarterMonthsAndYear,

// Start Dates

DayStart(TempDate) as CalendarDayStart,

WeekStart(TempDate) as CalendarWeekStart,

MonthStart(TempDate) as CalendarMonthStart,

QuarterStart(TempDate) as CalendarQuarterStart,

YearStart(TempDate) as CalendarYearStart,

// End Dates

DayEnd(day(TempDate)) as CalendarDayEnd,

WeekEnd(TempDate) as CalendarWeekEnd,

MonthEnd(TempDate) as CalendarMonthEnd,

QuarterEnd(TempDate) as CalendarQuarterEnd,

// Combo Date Examples

'Q' & Ceil(Month(TempDate)/3) & '/' & Year(TempDate) AS CalendarQuarterAndYear,

Year(TempDate) & '/' & 'Q' & Ceil(Month(TempDate)/3) AS CalendarYearAndQuarter,

'Wed ' & DayStart(WeekStart(TempDate) + 3) as CalendarWednesdays,

'Sun ' & DayStart(WeekStart(TempDate) + 3) as CalendarSunday

RESIDENT TempCalendar ORDER BY TempDate ASC;

DROP TABLE TempCalendar;

Re: same period for 3 date feild

tresB — Wed, 14 Aug 2013 09:29:56 GMT

you can try like this:

Load DateField1,

Year(DateField1) as Year1,

Month(FDateField1) as Month1,

'Q' & Ceil(Month(DateField1) / 3) as Quarter1

From ....;

Similarly for DateField2 and dateField3,

Load DateField2,

Year(DateField2) as Year2,

....;

Re: same period for 3 date feild

Wed, 14 Aug 2013 10:47:17 GMT

Dual(Year(Date) & '-Q ' & Ceil(Month(Date)/3) & '-M ' & Month(Date), Year(Date) & Ceil(Month(Date)/3) & Month(Date)) as YearQuarterMonth

topic Re: same period for 3 date feild in QlikView

same period for 3 date feild

Re: same period for 3 date feild

Re: same period for 3 date feild

Re: same period for 3 date feild

Re: same period for 3 date feild