Calender

[#1]

hi friends...

i am new in qlikview. please help me for building calender as i have three tables and all three tables having date columns with different names so how to build a calender as i have to consider all three date consider...

[#2]

sam error is coming....

[#3]

ya, i have tried that one also but wrong output is coming.....

[senpradip007]

Can you upload the sample app as its working fine at my side.

[#5]

suppose i have thses two tables having date fields as exam date and created date  then how to build calender by considering these two different date field  !

[#6]

Pradip Sen: i have tried this one also but above error is coming...

[rupaliqlik]

External Calender Code

for

i=1994 to 1996

For j=1 to 12

Calender:

load

$(i) as EXT_YEAR,

$(j) as EXT_MONTH ,

(

makedate($(i),$(j),recno()))as ACTUAL_DATE ,

Week((makedate($(i),$(j),recno()))) AS EXT_WEEK,

recno() as EXT_DAY

autogenerate(31);

next

next

[evan_kurowski]

Hello Ashish,

I see 'DD-MMM-YY' and 'DD-MM-YYYY' formats and I'm guessing the script header probably has something like 'D/M/YYYY' as the default.  Perhaps it is something in these varying formats that is preventing a capture of the beginning and end-point across the three sources, because otherwise the suggestions of code which loop between a min-max combo and fill in the date range are all standard and proven segments.

Maybe you should post the actual spreadsheet in this thread, or a reduced sample of it.  Once the contributors here have the actual spreadsheet, I'm sure someone will hook it up to a .QVW that demonstrates a proven solution.