Problem with Master Calendar

[Anonymous]

Hi guys,

I am creating a second Master Calendar but I'm having trouble. I already have one for Transactions, and now I want one for Actions.

Actions is loaded into QlikView via SQL:

LOAD

       `action_datetime`                               as [Action Datetime],

       date(floor(`action_datetime`))            as [Action Date],

        .....

SQL SELECT

....

And "Action Datetime" has this look in the database:

So I created a Master Calendar for actions in a text file (and I call it with Include$...). Find it attached (Actions_Calendar.txt).

[Action Date] is primary key, linked to other tables. When I do the preview in the table viewer it's correct:

But when I create a multitable in a sheet, looks like it is not working (The expression below is evaluated, though):

Does anyone know what's going on?

Thanks!

[rwunderlich · Accepted solution]

Your calendar looks incorrect based on the presence of the 1899 date -- means you are starting at Day 0. I think the problem is in your calendar script at:

TempActionCal:

LOAD

  date($(vMinDate)+ rowno() -1) AS TempActionDate

That should be $(vMinActionDate)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Anonymous]

Thanks! That was it!