Dynamically change the selected value of a button?

andypandy_swe — Tue, 18 Feb 2025 12:15:04 GMT

I have some data that contains an ID and a TYPE and then some measures that are displayed in a barchart.

The data looks like this:

ID TYPE MEASURE
600 A 36,2
600 B 12,8
700 A 18,0
700 B 44,4
...

To filter the barchart I have a select-list for the ID and buttonbar for the TYPE (A and B).
I now want to have a specific default value for the button bar that depends on the ID.
So that say the ID is 600 then the TYPE-button should have A selected but if I choose 700 then the B-button should be selected.
This pairing comes from a lookup-table that I have joined with my data so there is now a TYPE_DEFAULT column as well.

ID TYPE TYPE_DEFAULT MEASURE
600 A A 36,2
600 B A 12,8
700 A B 18,0
700 B B 44,4
...

The only way to control what item in the button bar is highlighted/selected seems to be to select that the "first" item should be highlighted/selected.
I figured it was ok if the order of A and B switched depending on the selected ID so my plan was to dynamically change the order.

I therefore renamed TYPE to TYPE A-B and set a custom sort on it so that A comes before B.
I then cloned that variable, called it TYPE B-A and set a custom sort on that where B comes before A.
I then created a calculated item A-B-A that says

IF ( 'TYPE_DEFAULT'n = 'A' )
RETURN 'TYPE A-B'n
ELSE 'TYPE B-A'n

I then set the button bar to use the calculated A-B-A -variable instead, but it doesn't work. When I select an ID in the dropdown list that is associated with the default value A, the button bar doesn't switch the order of the buttons.

However if I assign the TYPE A-B variable directly to the button bar, then the A-button comes first and is highlighted. The same the other way around so if I assign TYPE B-A, the B-button comes first and is highlighted.

So obviously the calculated item doesnt inherit the sort order of the variable it returns and my solution is a fail.

Can someone think of another solution?

Many thanks

topic Dynamically change the selected value of a button? in SAS Visual Analytics

Dynamically change the selected value of a button?