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.

erivera10
Contributor

Create two fields on master calendar

Someone knows how to create each week your start date and end date, something like this:

date,year, week, date_initial, date_end

x, 2016,1, 01/01/2016, 01/02/2016

x, 2016,2, 01/03/2016, 01/09/2016

x, 2016,2, 01/10/2016, 01/16/2016

add to my master calendar these two fields date_initial, date_end....

1 Solution

Accepted Solutions

Re: Create two fields on master calendar

Qlikview has native functions: weekend and week start.

use your Date field to create them

WeekEnd(date) as WeekEnd

WeekStart(date) as WeekStart

WeekEnd

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/w...

WeekStart

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/w...

Feeling Qlikngry?

How To /Missing Manual(25 articles)

1 Reply

Re: Create two fields on master calendar

Qlikview has native functions: weekend and week start.

use your Date field to create them

WeekEnd(date) as WeekEnd

WeekStart(date) as WeekStart

WeekEnd

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/w...

WeekStart

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/w...

Feeling Qlikngry?

How To /Missing Manual(25 articles)

Community Browser