topic help needed with master calendar in QlikView

help needed with master calendar

Tue, 17 Feb 2015 07:08:55 GMT

Hi All,

I am trying to create master calendar starting from last year to previous month of this year.

any help would be appreciated

FYI...

tresB — Tue, 17 Feb 2015 07:14:52 GMT

Try like:

let VMinDate=MakeDate(2014,01,01);
let VMaxDate=MonthStart(Today());

MasterCalendar:
Load Date($(VMinDate) + RecNo()) as TempDate
AutoGenerate VMaxDate-VMinDate ;

Tue, 17 Feb 2015 07:17:46 GMT

Hi Tresesco,

i have tried that and iam getting a strange year field like 1905,1906..

senpradip007 — Tue, 17 Feb 2015 07:21:08 GMT

Try like:

let VMinDate=Num(MakeDate(2014,01,01));
let VMaxDate=Num(MonthStart(Today()));

MasterCalendar:
Load Date($(VMinDate) + RecNo()) as TempDate
AutoGenerate VMaxDate-VMinDate ;

tresB — Tue, 17 Feb 2015 07:21:55 GMT

Sorry, add num() like:

let VMinDate=Num(MakeDate(2014,01,01));
let VMaxDate=Num(MonthStart(Today()));

MasterCalendar:
Load Date($(VMinDate) + RecNo()) as TempDate
AutoGenerate VMaxDate-VMinDate ;

Tue, 17 Feb 2015 07:25:05 GMT

Tq guys...

jagan — Tue, 17 Feb 2015 07:25:47 GMT

Hi Sruti,

Try this script

let VMinDate=Num(MakeDate(2014,1,1));

let VMaxDate=Num(MonthStart(Today()));

MasterCalendar:

Load Date($(VMinDate) + RecNo() -1) as TempDate

AUTOGENERATE (Num(Interval(VMaxDate-VMinDate, 'D')));

Regards,

Jagan.