BusinessObjects Board

Filtered Rows in more than data range

other Xcelsius - Crystal Dashboard Design
#1

Hi,

I need to use combo box filter to select the data corresponding to a year. I have implented it using the combox box with the insertion type ‘Filtered Rows’,. The problem is that I am only able to filter a given range of data and I would need to filter several other ranges. I have checked that the souurce data field does not allow to put more than a range. How could I achieve this desired behaviour?

alf_gon (BOB member since 2010-10-22)

Multiple rows selected by user input
1 Combo Box Populate 3 Graphs
#2

Hi,

Best way to do this is to set up multiple combo boxes to run different queries for each range. So query1 would return the year labels, query 2 would return the corresponding labels for query1 etc. This creates a cascading effect until the final query that passes all these selections and returns the corresponding data.

However if youre using static data what you’d need to do is set up the same multiple combo boxes, but your source data for combo 2 would need to refer to the destination range of combo 1, combo 3 source would be the destination from combo 2 etc. Only use this option is youre using a small dataset.

Michael McBennett :uk: (BOB member since 2002-08-19)

#3

Hi Michael,

Sorry but I’m a bit confused reading your answer. I have attached a xcelsius file that shows my current issue. As you can see I need to äpply row filtering over 2 diferent ranges. Could you kindly explain how to procedure over this sample?

Thanks a lot
Sample1.zip (7.0 KB)

alf_gon (BOB member since 2010-10-22)

#4

Hi, sorry misread your original post, I thought you wanted to use multi combos.

In order to use a single combo to control multi date ranges/components what you’ll need to do is (for this example):

  1. create an addittional combo for the second chart and set up parameters as you would normally.
  2. The selected item on the 2nd combo needs to refer to your combo 1 insertion cell (thats E9)
  3. Hide the second combo behind another component (send to back)

See attached (this is 2008 3.3)
Sample1_mmc.zip (11.0 KB)

Michael McBennett :uk: (BOB member since 2002-08-19)

#5

Perfect. Thanks a lot for open my eyes!

alf_gon (BOB member since 2010-10-22)

#6

sorry for the bump, but the above sample only works if your 2 data-area’s contain the exact same rows??

(so in the Sample1_mmc.xlf example 2009 and 2010)

Tiny :netherlands: (BOB member since 2004-11-10)

#7

Try changing the labels on the 2nd combo to cover the date range on the 2nd dataset (rather than the 1st).

Michael McBennett :uk: (BOB member since 2002-08-19)