cancel
Showing results for 
Search instead for 
Did you mean: 

Filtering in ComboBox

Former Member
0 Kudos

Hi Xcelcius gurus!!

I have a small scenario where I need some help.I have the following data in a table.

Codeline System

700 Q99

700 QFT

701 Y1Q

701 QRF

730 Q93

For this I have two combos,Combo1 and Combo2.

In Combo1, I need filtered values from Codeline and in Combo2, I need the corresponding Systems(based on selections of Combo1). Till here, I have suceeded. Now, in Combo1, I need another entry to be appended called "All". On selecting 'All', Combo2 should load all the entries of the column 'System'.

I do not wish to add the ALL in Column and other entries in System

How do we do this?

Edited by: Shashidhar N Garimella on Aug 20, 2010 6:46 AM

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member610149
Active Participant
0 Kudos

Hi Sashidhar,

Codeline System

700 Q99

700 QFT

701 Y1Q

701 QRF

730 Q93

I presume that by filtering the Characteristics Codeline, System, you may have to work with Keyfigure.

For that you must have a total keyfigure for ALL codelines logically as shown below.

Codeline System Keyfigure

All All 48

700 Q99 05

700 QFT 10

701 Y1Q 10

701 QRF 12

730 Q93 11

When you have selected ALL in codeline, there is no need of individual entry in System. Isnt it.

Please explore the possibility of using "Filter" component which may be of very much useful in such scenario.

Correct me if i misunderstood your requirement.

With best wishes

BaaRaa.

Former Member
0 Kudos

Hi Baskar,

Thanks for the info.However, there is yet another constraint here.

I have this data in an excel sheet.So i prefer to fetch data directly from Excel only than to fetch data from BW.

So, therefore, I may not want to use the KeyFigures or Characteristics here.

Please assume that the above data existed statically inside the Excel Sheet of the dashboard(XLF) file.

Regards,

Shashi

Former Member
0 Kudos

I would create to boxes one that would only display when all is selected in the first one and then the other would just show the individual values. You can then pick the correct data you want to display based on that. Just a thought....

Former Member
0 Kudos

Shashi,

By the look of it.I hope you are working on sap bw/bi ..I hope you will be getting data in the form of Excel directly from BEX.So what ever Bhaskar has told you ,can implement the same here in xcelsius.

let me know if you have any queries....

Former Member
0 Kudos

Hi Parvarthaneni,

That is exactly what my point is. I am not getting data from BW/BI. All the information required for creating this dashboard

is already in the form of Excel. My project is to develop a dashboard with this information only. And, I am struck at the the problem described. In my context , considering BW/BI is not at all required as my entire source data is present in worksheet form.

Regards,

Shashi

Edited by: Shashidhar N Garimella on Sep 27, 2010 10:00 AM

Former Member
0 Kudos

Hi,

What do you meant i am not getting data from BW/BI ? ? ? If you data in Excel you can create it rite......

Data in Excel -- yes... You can create dashboarad here...

Ask you dev team to get the data you require.....

Thanks for your time.

Regards,

satish.p

Former Member
0 Kudos

Yes Sathish,

I can create a dashboard with the Excel data currently. In fact, I have almost completed preparing the dashboard.That is not what the problem is about.In process dashboard making , I am stuck at a point (posted in the description of this thread). This is where I need help. Kindly go through the problem description (first post in the thread) and let me know if you got doubts..

Regards,

Shashi

Former Member
0 Kudos

Hi,

Since you dont want to add "ALL" How do you think you are going to get the data ?? ..I have done some dashboard's for a major client ,we do have this functionality "ALL"

Use of "ALL" To return summarized info or to show other enteries in that column.I generally use a .aspx code for this and then trigger the same an XML Data Button so that the data interaction is dynamic and all future changes will be seen here on the dashboard.

Can you please sent me the Excel data let me do this... parvathaneni.satish at G

Former Member
0 Kudos

Hi,

My problem is solved now.Now I am handling 'ALL' potion, external to XLF file.

When I import the workbook, the values get imported along with ALL portion.

Though this seems to be tedious solution, I could not see any better solution to beat this.

Regards,

Shashi

Former Member
0 Kudos

Can you please tell me how to add ALL option in the combo box?

I have the same requirement..I dont know how to do this?

Thanks,

Mini

Former Member
0 Kudos

Hi Mini,

I have handled the ALL requirement external to my XCelsius file. ie, I am considering ALL as any other item in the same column.

Probably, I can give you a few workarounds,if you let us know the kind of requirement and situation, you currently have.

Former Member
0 Kudos

Hi Shashidhar,

In the combo box one can select individual item..But my user wants to select multiple values by Holding control key or shift key.

Any clue??

Thanks,

Mini

Former Member
0 Kudos

Hi mini,

Have your tried using a LIST BUILDER(If screen space is not a constraint) or CHECK BOX. However, if you really want to know about multi-select option in combo please go through the following link.

http://myxcelsius.com/2010/08/31/multi-select-combo-box-xcelsius/

Hope it helps..

Former Member
0 Kudos

Space is a Constraint ..Otherwise I would have used List builder.

And We dont have licence to use Flex environement to use the code provided in the link.

how did you implemented in your project?

Thanks,

0 Kudos

HI Mini Patnaik...

We have a custom add-on component that would be a perfect fit for your requirement - it has multi-select capability with the All option also. Please

check the following link.

http://www.visualbis.com/blogs/xcelsius/2012/09/18/multi-select-combo-box-for-sap-businessobjects-da...

Regrads,

P.Gowri

Former Member
0 Kudos

Hi Shashi,

I have a similar requirement. Could you please tell me how to get ALL value in the combo box filter?

Please find the xlf file with sample values(change file extension).

Thanks a lot,

Arun