topic Re: Problem with Master Calendar in QlikView

Problem with Master Calendar

Anonymous — Fri, 23 Oct 2015 08:44:56 GMT

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!

Re: Problem with Master Calendar

rwunderlich — Fri, 23 Oct 2015 09:17:55 GMT

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

Re: Problem with Master Calendar

Anonymous — Fri, 23 Oct 2015 09:31:30 GMT

Thanks! That was it!