topic What's wrong with my calendar (attached below)? in QlikView

What's wrong with my calendar (attached below)?

Anonymous — Wed, 30 May 2012 11:24:23 GMT

What's wrong with my calendar (attached below)?

Sokkorn — Wed, 30 May 2012 11:29:39 GMT

Hi Friend,

Can you help to address your issue? I am very difficult to find your problem.

Regards,

Sokkorn

What's wrong with my calendar (attached below)?

Anonymous — Wed, 30 May 2012 11:32:42 GMT

I'm getting the following script errors when I reload

Field not found - <<=>

TempCalendar:

LOAD

+IterNo()-1 AS Num,

Date(+IterNo()-1) AS TempDate

AUTOGENERATE 1 WHILE (+IterNo()-1) <=

Table not found

MasterCalendar:

LEFT KEEP (CPI)

LOAD TempDate AS %_DateKey,

TempDate AS %_DateKeyCA,

week(TempDate) AS Week,

year(TempDate) AS Year,

month(TempDate) AS Month,

day(TempDate) AS Day,

weekday(TempDate) AS WeekDay,

'Q' & ceil(month(TempDate)/3) as Quarter,

date(monthstart(TempDate), 'MMM-YYYY') AS MonthYear,

week(TempDate)&'-'&Year(TempDate) AS WeekYear,

Year2Date(TempDate, 0, 1, 41059)*-1 AS CurYTDFlag,

Year2Date(TempDate,-1, 1, 41059)*-1 AS LastYTDFlag,

num(month(TempDate)) as Period

RESIDENT TempCalendar

ORDER BY TempDate Asc

Table not found

DROP TABLES statement

What's wrong with my calendar (attached below)?

Sokkorn — Wed, 30 May 2012 11:38:55 GMT

Hi,

+IterNo() ==> Should by omit + sign. Hence try to change from +IterNo() ==> IterNo()

Regards,

Sokkorn

What's wrong with my calendar (attached below)?

Anonymous — Wed, 30 May 2012 11:50:25 GMT

Your variabel vMinDate and vMaxDate are empty.

That is because the Date field in your DateTemp table is not filled.

What's wrong with my calendar (attached below)?

Anonymous — Wed, 30 May 2012 12:03:24 GMT

Dennis,

Will you please explain further?

I don't understand exactly what you are saying

DateTemp:

LOAD (Date(Date#(Date,'YYYY/MM/DD'),'DD/MM/YYYY')) as Date - these date fields in bold are not filled?

RESIDENT CPI

ORDER BY Date Asc;

LET vMinDate = Num(Peek('Date', 0, 'DateTemp'));

LET vMaxDate = Num(Peek('Date', -1, 'DateTemp'));

LET vToday = Num(today());

what does it mean or do you mean that they are not filled?

What's wrong with my calendar (attached below)?

Anonymous — Wed, 30 May 2012 12:11:02 GMT

Just Type

EXIT SCRIPT;

Below the LET lines and reload your document. Then take a look at your DateTemp table.

You will see it is empty.

Your min max variables are based on that table so they are also empty. That is why you get your error.

What's wrong with my calendar (attached below)?

Anonymous — Wed, 30 May 2012 12:19:03 GMT

Why is the DateTemp table empty?

Is there something I can do to make it not empty?

I don't understand why it's not working because i've used the exact same Calendar script in other models and they worked just fine

see other model with same calendar script attached

What's wrong with my calendar (attached below)?

Anonymous — Wed, 30 May 2012 12:28:34 GMT

It is empty because your script is wrong :

This: (Date(Date#(Date,'YYYY/MM/DD'),'DD/MM/YYYY')) as %_DateKey, is not working.

Try this:

DateTemp:

ADD LOAD Date#(Date,'YYYY/MM/DD') as Date

RESIDENT CPI

ORDER BY Date Asc;

LET vMinDate = Peek('Date', 1, 'DateTemp'); //LET ... evaluates the expression on the right side of the ’=’ before it is assigned to the variable

LET vMaxDate = Peek('Date', -1, 'DateTemp');

LET vToday = Num(today());

This should get rit of your errors.

But your date format in your data is YYYY/MM/DD and in your calander is not so also try this:

Date#(Date,'YYYY/MM/DD') as %_DateKey,

I hope this is helpfull.

What's wrong with my calendar (attached below)?

Anonymous — Wed, 30 May 2012 12:35:36 GMT

hmm, still not working for me

What's wrong with my calendar (attached below)?

Anonymous — Wed, 30 May 2012 12:46:05 GMT

What is not working? Still an error?

What's wrong with my calendar (attached below)?

Anonymous — Wed, 30 May 2012 12:54:21 GMT

it's loading just fine now, but the fields that come into my model have no values

What's wrong with my calendar (attached below)?

Anonymous — Wed, 30 May 2012 12:58:35 GMT

Please share so we can take a look.

What's wrong with my calendar (attached below)?

Anonymous — Wed, 30 May 2012 13:02:21 GMT

updated model attached

What's wrong with my calendar (attached below)?

Anonymous — Wed, 30 May 2012 13:31:29 GMT

Just take a closer look at your script:

CPI:

LOAD ...

(Date(Date#(Date,'YYYY/MM/DD'),'DD/MM/YYYY')) as %_DateKey,

Is not working
%_DateKey is empty

And you are connecting your calender to that empty field.