topic Re: List Box default setting in SAS Visual Analytics

List Box default setting

BlueBrazil — Fri, 20 Nov 2015 11:14:57 GMT

I have set up 2 List Boxes based on the same dimension to select 1 value each. I then set up another list box, based on the same dimension, which filters the single value from the first 2 List Boxes, thereby giving me 2 values displayed in the 3rd List Box. I now want to do a select all on the 3rd List Box, automatically. Basically, I want the 3rd List Box to have a default setting of Select All so it can interact with Gauge 3.

The idea is to select value 1 from List Box 1 using Dimension 1 and display in Gauge 1. Select value 2 from List Box 2 using Dimension 1 and display in Gauge 2. List Box 3 uses a filter to display value 1 and value 2 in List Box 3 using Dimension 1 and displays the total in Gauge 3.

Hope this makes sense.

Re: List Box default setting

PeterWijers — Sun, 22 Nov 2015 07:15:22 GMT

Hello,

Sadly for me it not clear want you really expect to get out of it.

Could you please set-up a small sample with 3-5 values or so and describe the expected filter result.

Samples often make it more clear than words, but that's only my personal opinion.

This way we might be able to answer your question, or find a work around with the same result.

Greetings Peter

Re: List Box default setting

BlueBrazil — Mon, 23 Nov 2015 09:11:28 GMT

Peter

Thanks for your reply. Please see attached. I need to have Drop Down List 3 set to Select All.

Regards

Re: List Box default setting

PeterWijers — Mon, 23 Nov 2015 18:32:15 GMT

Hi there,

Looking at your attached picture, this solution might work.

If you add a parameter to both the DropDownLists, the selected values will be stored in the two parameters.

Simply add a filter to the 3rd DropDownList that uses the both parameters as a filtering value.

This way the 2 selected values of DropDownList 1 and 2 will filter DropDownList 3.

Anyway you van link the DorpDownLists to any other graphics or so.

Greetings and good luck.

Peter

Re: List Box default setting

TejaSurapaneni — Tue, 24 Nov 2015 07:20:10 GMT

Hello,

From my understanding, you want to display 'n' values in list control 3..!, which are selected from List control 1 & 2

for example:

You have selected 'X' from List control1 and 'Y' from list control2.

want to show both 'X' and 'Y' In List control3...

Thanks & Regards,

Teja Surapaneni.

Re: List Box default setting

PeterWijers — Tue, 24 Nov 2015 08:18:40 GMT

Teja,
thats the way my solution works now.
Greetings

Re: List Box default setting

BlueBrazil — Wed, 25 Nov 2015 09:12:22 GMT

Thanks for your help. I had gone down the road of filtering a Gauge showing the values held in the 2 parameters but having a problem with the syntax. The 2 parameters GaugeDim01 & GaugeDim02 hold the 2 text values:

Regards

Re: List Box default setting

TejaSurapaneni — Thu, 26 Nov 2015 07:03:51 GMT

Yes Peter, it will.....

Teja Surapaneni.

Re: List Box default setting

PeterWijers — Thu, 26 Nov 2015 09:05:17 GMT

hi there,

i would suggest to use the and function and solit the filter in two lines

AND ( (dim01 = variable ) (dim02 = variable) )

if you want an AND function of cource, you can also use OR function if desired. etc.

Greetings

ps i described the formula, if you need it in VA grafics i could provide it to yoy,

Re: List Box default setting

SKG — Thu, 15 Sep 2016 07:43:04 GMT

Hi Peter,

But could you please tell me one thing that how to display a value of dropdown list in text input?

Re: List Box default setting

SKG — Thu, 15 Sep 2016 07:50:27 GMT

Hi Blue,
Could you please tell me in brief that how you did it?

Actually i'm facing same problem. my requirement is i want to display a value of dropdown list in text input

Re: List Box default setting

PeterWijers — Wed, 21 Sep 2016 05:25:29 GMT

Hi there,

The item was about pre-filtering another dropdownList with a previous selected value.

Sadly your request is not possible as far as I know.

Anyway, what would be the use of entering a selection in a "INPUT" box that is ment to be for inputting a unique value of a certain variable.

If you want just want to put your selection on a certain location (visualy) thats different but why would you want to do that.

Please explain the problem you want to solve, surely we will find a way to do it.

Greetings Peter

Re: List Box default setting

SKG — Wed, 21 Sep 2016 05:43:05 GMT

Hi Blue,

I resolved my issue. Thanks for your help

Re: List Box default setting

SKG — Wed, 21 Sep 2016 05:48:30 GMT

Hi Peter,

Sorry, I resolved my issue