- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Creating a date drop down filter using a Chart
Hi Team,
I'm trying to create a Year,Month and Quater filter using a drop down option in a pivot chart.
When I tired to populate the selected year it is giving the selection but when I opt for clear option then it is replaced by '-' .
Can some one help me to identify the way to replace the '- ' with any default year when you click clear.
Also for Month when nothing is selected then it showing '-'.
Please find the source data and qvw.
Thanks In advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be using label expression like this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Vijaya,
You can use getselectedcount().
for E.g. : If(getselectedCount(Year) = 0,Max(Year),Year).
Check if its work for u.
-Vanraj Dinesh Bohra
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi ,
Thank you for your quick response,both the way worked for the Year.
But its not reflecting for month.can you please help me out
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Since your month field is a text field, max() would not work directly. Try label expression like:
=Month(max(Date#(Month,'MMM')))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Tresesco,
Thank you.
But the output was showing only one month in display (i.e max month is shown),I think user might be confused if it is showing only month,Can we have any default value if nothing has been selected
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It would be great help if you let me know for quarter as well
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't understand. You have separate fields for month, year and quarter and you want them to be available like in a drop down using straight table. Could you explain a bit more? May be explain with an example.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please find attached qvw