topic Re: Master Calendar Flag in QlikView https://community.qlik.com/t5/QlikView/Master-Calendar-Flag/m-p/1202839#M877517 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>If(TempDate &gt;= YearStart(Today(1), -1) and TempDate &lt;= MonthEnd(Today(1), -12), 1, 0) as Flag</STRONG></P></BODY></HTML> Tue, 18 Oct 2016 14:09:51 GMT sunny_talwar 2016-10-18T14:09:51Z Master Calendar Flag https://community.qlik.com/t5/QlikView/Master-Calendar-Flag/m-p/1202838#M877515 <HTML><HEAD></HEAD><BODY><P>Looking for a master calendar flag that shows me last year through this month last year. </P><P>Ex:1</P><P>Today is Oct 18, 2016</P><P></P><P>I need a flag that will grab all dates from</P><P></P><P>Jan 1, 2015 - Oct 31, 2015.</P><P></P><P>Ex 2:</P><P></P><P>Today is Jan 17,2016</P><P></P><P>Flag should mark all dates</P><P></P><P>Jan 1,2015 - Jan 31,2015</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-Flag/m-p/1202838#M877515 jeckstein 2020-11-25T16:16:04Z Re: Master Calendar Flag https://community.qlik.com/t5/QlikView/Master-Calendar-Flag/m-p/1202839#M877517 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>If(TempDate &gt;= YearStart(Today(1), -1) and TempDate &lt;= MonthEnd(Today(1), -12), 1, 0) as Flag</STRONG></P></BODY></HTML> Tue, 18 Oct 2016 14:09:51 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-Flag/m-p/1202839#M877517 sunny_talwar 2016-10-18T14:09:51Z