BusinessObjects Board

xcelsius text box based on the value of combo box

other Xcelsius - Crystal Dashboard Design
#1

xcelsius text box based on the value of combo box, for example i have a drill down on the Years and when the user selects any year from the drop down combo box the chart has to give the values to that year as well i need to display the selected year at the bottom of the chart, but the bottle neck is the years are customized in the label menu of the combo box

Cristina (BOB member since 2009-02-27)

#2

Hi Cristina,

As far as I understand your query, you are using “filtered rows” in combo-box, and filtering out the values pertaining to the selected year, puttting into your destination cells, and using that destination as the source for your chart, right? So, for displaying the value of the year below the chart, you could use the “Insert selected item” feature of the combo-box present under Behavior tab. Insert into a spreadsheet cell, and make the text-box pick the value from that cell itself.

But if this is not the case, then please elaborate in detail, giving a glimpse of your customized years, and how you want it to look in the chart.

Regards

mehak83 (BOB member since 2011-06-28)

#3

I am selecting years 2009,2008 from the Query and i have to display 2009-2010, 2008-2009. i used Labels under General for the Combo box, so i can see 2009-2010.However, i need to display the same year to display as a legend at the bottom of the chart

Cristina (BOB member since 2009-02-27)

#4

If I understand correctly, I think this might work for you:

Create a formula next to your year value. If your year is in cell G9 then the formula would be like this:

=G9&"-"&G9+1

So if the year the query returns is 2008, then the formula cell will return 2008-2009.

Then point the Category Axis labels to the formula column rather than the year column returned by the query. This will give you the correct display for the chart legend.

Hope this helps,
~Roxanne

RoxanneP :us: (BOB member since 2006-08-07)

#5

Hi Cristina,

I still did not get exactly which format of year you want to display as your chart legend. However, I have incorporated both ways in the attached XLF. Hope it helps.
In both the scenarios, I took an extra combo-box and made it hidden behind the chart.

Regards

PS: Cannot see the attachment after posting this comment. So, will try to explain.
Case 1: If legend to display 2008, simply take the year value in scope of filtered rows of the hidden combo-box. The hidden combo-box will have labels from query (2008, 2009, etc). Make the selected label as “dynamic” and select the destination of main combo-box as selected item for hidden combo-box.

Case 2: If legend to display 2008-2009, insert the selected item of main combo-box into a cell, and take that cell as the series name in your chart. Filter out only value cells, leaving the year name when you apply filter through hidden combo-box.
Test.zip (53.0 KB)

mehak83 (BOB member since 2011-06-28)