Discussion Board for collaboration on QlikView Scripting.
I have a question here.
I make a master calendar which works fine.
But I need to change some days from a week to other week.
In this year Q1 ends in week 14 with 30 and 31, but I have to change this two days to week 13.
Is it posible?
The actual solution is a excel this dates, but I want to do it in script.
In preceding load you can use if
if (Qtr=Q1 and month = ...and date=....... ,13,Week as week
its just a example .
I had try this:
Where Week(QuarterEnd(Date)) > Week;
Week-1 as "Week",
Where Week(QuarterEnd(Date)) = Week;
DROP Table CalendarTMP;
Where CalendarTMP comes from Master Calendar.
What dou you think?