Create two fields on master calendar

[erivera10]

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....

[robert_mika · Accepted solution]

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)