Hello,
I want my DropDownList to show always the latest month by default. But the user should still be able to pick an other month. I don't want to resave my report each month to have the latest month there.
Any tips?
Filip
Discussed this with SAS Development, during a user meeting 2 weeks ago. Its a new request but not in yet.
The idea is to have it parameter controlled, so a parameter could calculate the defaults for an object. (or two for a slider slider bar) etc.
I also face the same issue to often.
There is the option to make a DropDownList depending on a parameter (to reduce selectable options) but thats not what you expect. (as far as I understand)
So you could automaticaly only have the dates from the actual month present.
Greetings
Hi,
To get the feel what you want, you have to add one "list object" in obove snapshot of the report.
May be this solution could help you :-
1) Create a calculated Item "Month Number" as" Month(DatePart(calldate))"
2) Create another calculated Item "Present Month Indicator" as :-
IF ( Month Number = Month(DatePart(Now())) )
RETURN 1
ELSE 0
3) Create a Custom Category "Month Name" based on "Month Number" created in step 1 and create 12 labels as jan, feb, mar etc and assign the corresponding values from "Month Number" distinct Values.
Now in the design part of the report :-
a) Add list object and assign the category as "Month Name" that we created in step 3 and apply a advanced filter as "present month indicator <> 0".
b) Uncheck the "Required" in the properties of list object.
c) Now simply give the interaction from "List object" ----> "Drop Down List" and from "Drop Down List"----> "Treemap".
So whenever the month changes, that particular month will be displayed in the list and the drop down list will contain the "calldate" for the same month.
Now if user wants to pick from other month, they can just uncheck the month name in the "List object".
Hope so, this helps you if I understood your requirement correctly.
Regards,
Abhishek
Hi Abhishek,
I tried your solution but still have one problem. Maybe you can help me out with this last issue.
I have a "list filter month number1" that is filtered by the present month indicator as you mentioned.
Also this "list filter month number1" filters a second filter "filter month number2". "Filter month number2" filters the object.
The "filter month number 1" does not change immediately into the new month (for example last 1 december) as the present month indicator changes. It still gives the old month (november) and the user has to click the filter to change it into (december).
If the end user still has to click the filter that he/she can also use a 'normal' filter and choose the last month.
How to make sure that the end user does not have to click the first filter?
make the dropdown as required field and then right click and sort it by descending order.
That should be able to show the latest month on the top.
Thanks
Amol
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.