topic Re: Dynamic Default Date in Drop Down List - Latest Month in SAS Visual Analytics

Dynamic Default Date in Drop Down List - Latest Month

max00d — Tue, 14 Jul 2015 15:41:53 GMT

I am trying to create a way to get the default selection in a listbox to be the latest month. As time goes on this obviously changes. This seems like it should be easy but I just cant figure it out. Can anyone help? Thanks

Re: Dynamic Default Date in Drop Down List - Latest Month

TejaSurapaneni — Wed, 15 Jul 2015 09:11:40 GMT

Hello Max,

Is it List (Controls) or List table?

Thanks & Regards,

Teja Surapaneni

Re: Dynamic Default Date in Drop Down List - Latest Month

max00d — Wed, 15 Jul 2015 09:16:34 GMT

it's in a drop-down list control

Thaks

Re: Dynamic Default Date in Drop Down List - Latest Month

TejaSurapaneni — Wed, 15 Jul 2015 12:57:54 GMT

Hello,

I don't think so it is possible!!!!, Lets see some of our community members will give us solution.

Thanks & Regards,

Teja Surapaneni.

Re: Dynamic Default Date in Drop Down List - Latest Month

RobNewZealand — Thu, 16 Jul 2015 05:17:40 GMT

Hey guys, One example we have is do it on the data side so basically the dataset is amended each month. We have a example of this... which works reasonabily well , however when you want to use the functionality of difference between this period and last period I imagine its going to break. This is something im trying to look into at the moment. So sorry not really a answer but feeling your pain... Cheers Rob

Re: Dynamic Default Date in Drop Down List - Latest Month

Explore_SAS — Thu, 16 Jul 2015 15:11:00 GMT

Hey max,

I think its doable, can you try below option and let me know if it works for you.

First make your dropdown value an required field. ( Go to the properties tab and navigate to your dropdown control and check the Required check box )

That will make you mandatory to select the field in the dropdown. Then right click your dropdown go to the "sort frequency" option and change it to descending.

let me if it works for you.

Thanks

Amol

Re: Dynamic Default Date in Drop Down List - Latest Month

TejaSurapaneni — Thu, 16 Jul 2015 16:16:46 GMT

Hi,

There is a related discussion

Thanks & Regards,

Teja Surapaneni

Re: Dynamic Default Date in Drop Down List - Latest Month

Fredrik_Hansson — Mon, 26 Feb 2018 10:07:51 GMT

Do you mean this?

https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-set-default-date-value-for-a-report-using-SAS-VA-Report/td-p/405188