topic Re: Create two fields on master calendar in QlikView https://community.qlik.com/t5/QlikView/Create-two-fields-on-master-calendar/m-p/1152868#M629700 <HTML><HEAD></HEAD><BODY><P>Qlikview has native functions: weekend and week start.</P><P>use your Date field to create them</P><P>WeekEnd(date) as WeekEnd</P><P>WeekStart(date) as WeekStart</P><P></P><P>WeekEnd</P><P><A href="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/weekend.htm" title="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/weekend.htm">https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/weekend.htm</A></P><P></P><P>WeekStart</P><P><A href="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/weekstart.htm" title="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/weekstart.htm">https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/weekstart.htm</A></P><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: 'comic sans ms', sans-serif;">Feeling Qlikngry?</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="8342" data-objecttype="102" href="https://community.qlik.com/docs/DOC-8342" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">How To /Missing Manual(25 articles)</A></P></BODY></HTML> Wed, 27 Jul 2016 04:51:46 GMT robert_mika 2016-07-27T04:51:46Z Create two fields on master calendar https://community.qlik.com/t5/QlikView/Create-two-fields-on-master-calendar/m-p/1152867#M629699 <HTML><HEAD></HEAD><BODY><P>Someone knows how to create each week your start date and end date, something like this:</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">date,year, week, date_initial, date_end</SPAN></P><P>x, 2016,1, 01/01/2016, 01/02/2016</P><P>x, 2016,2, 01/03/2016, 01/09/2016 </P><P>x, 2016,2, 01/10/2016, 01/16/2016</P><P></P><P>add to my master calendar these two fields <SPAN style="font-size: 13.3333px;">date_initial, date_end....</SPAN></P></BODY></HTML> Wed, 27 Jul 2016 04:33:53 GMT https://community.qlik.com/t5/QlikView/Create-two-fields-on-master-calendar/m-p/1152867#M629699 erivera10 2016-07-27T04:33:53Z Re: Create two fields on master calendar https://community.qlik.com/t5/QlikView/Create-two-fields-on-master-calendar/m-p/1152868#M629700 <HTML><HEAD></HEAD><BODY><P>Qlikview has native functions: weekend and week start.</P><P>use your Date field to create them</P><P>WeekEnd(date) as WeekEnd</P><P>WeekStart(date) as WeekStart</P><P></P><P>WeekEnd</P><P><A href="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/weekend.htm" title="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/weekend.htm">https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/weekend.htm</A></P><P></P><P>WeekStart</P><P><A href="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/weekstart.htm" title="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/weekstart.htm">https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/weekstart.htm</A></P><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: 'comic sans ms', sans-serif;">Feeling Qlikngry?</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="8342" data-objecttype="102" href="https://community.qlik.com/docs/DOC-8342" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">How To /Missing Manual(25 articles)</A></P></BODY></HTML> Wed, 27 Jul 2016 04:51:46 GMT https://community.qlik.com/t5/QlikView/Create-two-fields-on-master-calendar/m-p/1152868#M629700 robert_mika 2016-07-27T04:51:46Z