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
... View more
