topic How to add a Time dimension? in QlikView

How to add a Time dimension?

Tue, 28 Apr 2009 18:38:44 GMT

I want to add three list boxes with Year,Month and Day. Is there any in built functionality

How to add a Time dimension?

Tue, 28 Apr 2009 18:55:09 GMT

check this post http://www.quickqlearqool.nl/?p=160

example one should do the trick.. make sure you manually replaces al the 'qoutes' .. see last comments in the post!

How to add a Time dimension?

Tue, 28 Apr 2009 18:58:01 GMT

I don't exactly know what you mean, but if you already have a date value available you can create a List Box based on an expression:

=Year(Date)

How to add a Time dimension?

prieper — Wed, 29 Apr 2009 04:20:47 GMT

Hi,

would suggest to review date/time-functions in the OL-Help, there are various useful functions available: you mentioned already Year, Month, Week and - seems to be more useful - Quartername, Monthname, Weekname are pretty useful in listboxes

HTH

Peter

How to add a Time dimension?

Anonymous — Wed, 29 Apr 2009 20:37:02 GMT

A typical example:


LET Start = floor(yearstart(addmonths((today()), -36)));
LET End = floor(num(yearend(addmonths((today()), 36))));
LET NumOfDays = End-Start+1;
Date_src:
LOAD
 $(Start)+rowno()-1 as DateID
AUTOGENERATE NumOfDays;
Date:
LOAD
 DateID,
 date(DateID) as Date,
 day(DateID) as Day,
 week(DateID)as Week,
 month(DateID) as Month,
 dual(month(DateID) & '-' & right(year(DateID),2),
 year(DateID) & num(month(DateID), '00')) as MonthYear,
 year(DateID) as Year,
 weekday(DateID) as Weekday,
 if(weekday(DateID)>4, 0, applymap('HolidayMap',left(date(DateID),5),1)) as WorkDay
RESIDENT Date_src;
DROP TABLE Date_src;

Regards,
Michael

How to add a Time dimension?

Thu, 30 Apr 2009 12:39:57 GMT

Thanks a lot Michael!