topic Re: Time Dimention in QlikView

Time Dimention

coddra_6 — Wed, 30 Apr 2014 20:07:24 GMT

Hi,

I have to create a time dimention and I need to get the next structure:

Date| Year | Month | Day

And I need it to be since '01/01/2012' up to now.

I wanna know if exists some CURSOR statement that I can use in QlikView or maybe some DO-WHILE statement that adds one day to the date up to now and stores them in a qvd?

Hope your help!!

thanks

Re: Time Dimention

Clever_Anjos — Wed, 30 Apr 2014 20:17:31 GMT

load
    date,
    year(date) as year,
    Month(date) as month,
    Day(date) as day;
load
    date(Today()-RecNo()) as date
AutoGenerate (Today()-MakeDate(2012))

Re: Time Dimention

Wed, 30 Apr 2014 20:17:49 GMT

Hi Dario

this should be very good starting point:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

regards

Darek

Re: Time Dimention

simondachstr — Wed, 30 Apr 2014 20:17:54 GMT

Do-While statement exists and a so called Autogenerate function will create a row for each loop in your table thus populating all necessary dates. Have a look at the QlikView Reference Manual.

Alternatively, this topic is also covered when creating a "Master Calendar".. search the forums for that keyword and you should find plenty of code example & information.

Re: Time Dimention

coddra_6 — Wed, 30 Apr 2014 20:29:18 GMT

Thanks you so Much!!

Re: Time Dimention

Anonymous — Wed, 30 Apr 2014 20:33:28 GMT

Here is one more: http://community.qlik.com/docs/DOC-1310

Re: Time Dimention

MK_QSL — Wed, 30 Apr 2014 21:06:58 GMT

Little Change on Clever's Script

load

date,

year(date) as year,

Month(date) as month,

Day(date) as day;

load

date(Today()-RecNo()+1) as date

AutoGenerate (Today()-MakeDate(2012)+1)