Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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.

Tags (1)
1 Reply
Highlighted
Not applicable

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

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?