Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
sam error is coming....
ya, i have tried that one also but wrong output is coming.....
Can you upload the sample app as its working fine at my side.
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 !
Pradip Sen: i have tried this one also but above error is coming...
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
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.