topic Re: Calendar Object to select all data for Current Month or preceding 3 in QlikView https://community.qlik.com/t5/QlikView/Calendar-Object-to-select-all-data-for-Current-Month-or/m-p/783308#M1035343 <HTML><HEAD></HEAD><BODY><P>Hi, I'm facing a similar question. I'm trying to show a formula that tabulates the counts for the preceding 2 and 3 months respectively. Did you manage to get the formula for preceding month's count?</P></BODY></HTML> Mon, 18 May 2015 06:41:10 GMT 2015-05-18T06:41:10Z Calendar Object to select all data for Current Month or preceding 3 https://community.qlik.com/t5/QlikView/Calendar-Object-to-select-all-data-for-Current-Month-or/m-p/783307#M1035342 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to create a calendar object where the user can select a Year &amp; Month, displayed as one ('2015 January', '2014 December', etc) and the table will return all data for that Month.&nbsp; When the user navigates to the sheet, the calendar should default to the Current year/Month, based on yesterday's date and then limit the the possible selections the either current month or 1 of the preceding 3.</P><P></P><P>Is this possible, if so how?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 13 Jan 2015 16:49:14 GMT https://community.qlik.com/t5/QlikView/Calendar-Object-to-select-all-data-for-Current-Month-or/m-p/783307#M1035342 2015-01-13T16:49:14Z Re: Calendar Object to select all data for Current Month or preceding 3 https://community.qlik.com/t5/QlikView/Calendar-Object-to-select-all-data-for-Current-Month-or/m-p/783308#M1035343 <HTML><HEAD></HEAD><BODY><P>Hi, I'm facing a similar question. I'm trying to show a formula that tabulates the counts for the preceding 2 and 3 months respectively. Did you manage to get the formula for preceding month's count?</P></BODY></HTML> Mon, 18 May 2015 06:41:10 GMT https://community.qlik.com/t5/QlikView/Calendar-Object-to-select-all-data-for-Current-Month-or/m-p/783308#M1035343 2015-05-18T06:41:10Z