topic Date Grouping in QlikView https://community.qlik.com/t5/QlikView/Date-Grouping/m-p/327744#M120677 <HTML><HEAD></HEAD><BODY><P>so, why don't you construct a formula like</P><P>IF(MyDate &gt; EndOfFiscalYear, 'Beyond Fiscal Year', MyDate)&nbsp;&nbsp;&nbsp;&nbsp; AS DateCalculated</P><P></P><P>HTH<BR />Peter</P></BODY></HTML> Wed, 25 May 2011 20:35:31 GMT prieper 2011-05-25T20:35:31Z Date Grouping https://community.qlik.com/t5/QlikView/Date-Grouping/m-p/327743#M120676 <HTML><HEAD></HEAD><BODY><P>I have a date field with forward looking dates (forthcoming orders). What I wouldl like to have happen, is if the date is greater than my fiscal year end month, that all of the dollars associated with the greater dates can be grouped and summed as a "Beyond" date. The rub is I would like it to be part of the date selection. </P><P>So my fiscal year goess from April 2011 - Mar 2012. I need to look at sales by month, but also want to know how many dollars lies outside of my fiscal.</P><P></P><P>Thanx</P></BODY></HTML> Wed, 25 May 2011 15:14:42 GMT https://community.qlik.com/t5/QlikView/Date-Grouping/m-p/327743#M120676 2011-05-25T15:14:42Z Date Grouping https://community.qlik.com/t5/QlikView/Date-Grouping/m-p/327744#M120677 <HTML><HEAD></HEAD><BODY><P>so, why don't you construct a formula like</P><P>IF(MyDate &gt; EndOfFiscalYear, 'Beyond Fiscal Year', MyDate)&nbsp;&nbsp;&nbsp;&nbsp; AS DateCalculated</P><P></P><P>HTH<BR />Peter</P></BODY></HTML> Wed, 25 May 2011 20:35:31 GMT https://community.qlik.com/t5/QlikView/Date-Grouping/m-p/327744#M120677 prieper 2011-05-25T20:35:31Z