Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calendar Object to select all data for Current Month or preceding 3

Hi,

I'm trying to create a calendar object where the user can select a Year & Month, displayed as one ('2015 January', '2014 December', etc) and the table will return all data for that Month.  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.

Is this possible, if so how?

Thanks in advance.

1 Reply
Not applicable
Author

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?