Not applicable
2015-08-04
11:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date Button/Filter: Last 12 Months
I have many sheets which use a date field within charts. Similar to a list box to filter by year, I'd like to have an option for the user to select Last 12 Months instead of manually picking 365 days.
Is this possible? Is it better as a button? How would I write this expression? Basically it is if my date field is >= 365 days ago, show it if clicked or if deslected show all data.
Thanks in advance!
1 Solution
Accepted Solutions
maximiliano_vel
Partner - Creator III
2015-08-04
11:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
From Recipes | QlikView CookBook - Rob Wunderlich
Regards
3 Replies
maximiliano_vel
Partner - Creator III
2015-08-04
11:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Kushal_Chawda
MVP
2015-08-04
12:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create field monthyear using monthname(Date)
Create expression:
=sum({<year,month,monthyear={">=$(=addmonths(max(monthyear),-11))<=$(=addmonths(max(monthyear),0))"}>}Sales)
1,816 Views
Not applicable
2015-08-04
04:09 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you! This was perfect!
1,816 Views