Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

weekend in Master Calendar

We have volume in Saturday and Sunday. But we want to add saturday volume to friday and sunday volume to monday.

How do we change master calendar for this requirement? We don't want to change anything on the database table.we prefer Changes in the master calendar .

Tags (1)
2 Replies
Not applicable

Re: weekend in Master Calendar

If you only need to fool the system I would add a column in your master calendar with tha new value that you need to point, then use it instead of the old one, so you calendar would look like this:

KeyDayNew Day
11/04/2014FridayFriday
12/04/2014SaturdayFriday
13/04/2014Sunday

Monday

Of course you can change the labels so the new column be the old one, I'm trying to understand what you need and this is what occurs to me but if not please let me know.

MVP
MVP

Re: weekend in Master Calendar

You can create a DayFlag in your master calendar script..

IF(WeekDay(Date) = 5, Dual('Fri',4), IF(WeekDay(Date) = 6, Dual('Mon',0), Dual(WeekDay(Date),WeekDay(Date)))) as DayFlag