Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
Thanks! That was it!