topic Re: How to delete Negative months in Master Calendar in QlikView https://community.qlik.com/t5/QlikView/How-to-delete-Negative-months-in-Master-Calendar/m-p/878363#M990216 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Try this </P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">if(Year(tmp_Date)=WeekYear(tmp_Date), Week(tmp_Date) - Week(MonthStart(tmp_Date)) + 1,&nbsp; Week(tmp_Date) - Week(MonthStart(tmp_Date)) + 1) AS [Week in Month], </P></BODY></HTML> Wed, 15 Jul 2015 10:37:17 GMT sunilkumarqv 2015-07-15T10:37:17Z How to delete Negative months in Master Calendar https://community.qlik.com/t5/QlikView/How-to-delete-Negative-months-in-Master-Calendar/m-p/878362#M990215 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P>I have the following Scenario ...</P><P><IMG alt="Calendar.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92921_Calendar.png" style="height: 56px; width: 620px;" /></P><P></P><P>if(Year(tmp_Date)=WeekYear(tmp_Date), Week(tmp_Date) - Week(MonthStart(tmp_Date)) + 1,&nbsp; Week(tmp_Date) + 52 - Week(MonthStart(tmp_Date)) + 1) AS [Week in Month],&nbsp; </P><P></P><P>How can i delete Negative Months in master calendar.</P><P>Thanks</P><P>Madhu</P></BODY></HTML> Wed, 15 Jul 2015 10:35:44 GMT https://community.qlik.com/t5/QlikView/How-to-delete-Negative-months-in-Master-Calendar/m-p/878362#M990215 madhubabum 2015-07-15T10:35:44Z Re: How to delete Negative months in Master Calendar https://community.qlik.com/t5/QlikView/How-to-delete-Negative-months-in-Master-Calendar/m-p/878363#M990216 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Try this </P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">if(Year(tmp_Date)=WeekYear(tmp_Date), Week(tmp_Date) - Week(MonthStart(tmp_Date)) + 1,&nbsp; Week(tmp_Date) - Week(MonthStart(tmp_Date)) + 1) AS [Week in Month], </P></BODY></HTML> Wed, 15 Jul 2015 10:37:17 GMT https://community.qlik.com/t5/QlikView/How-to-delete-Negative-months-in-Master-Calendar/m-p/878363#M990216 sunilkumarqv 2015-07-15T10:37:17Z