Reset a selector like combo box or radio button

1. Bind labels of the selector (eg. B2:B5)
2. Set Insertion type and destination (eg. C2)
3. Set the selected item type on Dynamic on the behaviour tab of the selector
4. Bind the item to a cell (eg F2)

5. Bind source cell of Push button (eg. E2)
6. Bind destination cell of Push button (eg. F2, same as selected item of combo!)
7. Add formula in source cell push =if(F2=”x”,B2,”x”)
8. Add “x” value in destion cell F2

Comes in handy when you want to reset only certain parts of the dashboard and not resetting it to its initial state (as you do with the reset button).

Recent Related Posts
Femke Kooij is a dashboard and report designer, developer and educator specializing in SAP | BusinessObjects Dashboards (better known as Xcelsius) and Crystal Reports. She has also a lot of experience with other SAP | BusinessObjects toolings like, Web Intelligence (WebI), Information Design Tool (Universe Designer), BusinessObjects Data Services (BODS) and the overall server platform BusinessObjects Enterprise (Launchpad, CMC). She spends a lot of her time thinking about and sharing her knowledge of Xcelsius to others through her own blog. Lately she is exploring other visualization tools like Qlikview and Tableau. On the later she is also posting some experiences. Currently she is in the employment of Cognizant Technology Solutions. Her blog only contains her personal views, thoughts and opinions. It is not endorsed by Cognizant Technology Solutions nor does it constitute any official communication of Cognizant Technology Solutions.

This entry was posted in Components, Design, Xcelsius and tagged , , , , , . Bookmark the permalink.

4 Comments to Reset a selector like combo box or radio button

  1. ehk says:

    thanks!! very helpful to me. thanks again!

  2. Pawan says:

    Nice article…keep it up..

  3. Krish says:

    Hi,
    I tried the above logic but its not working for me, Could you please give me the source file so that i can understand the logic better.

    Cheers,

  4. DoubleM says:

    Hi,

    thanks for this post. It helps me to start thinking about this nice tool of dynamicaly filling a drilldown box or whatever form another source than itself …

    But after reproducing your scenarion in Xcelsius I was wondering, why you use such a circumstantial way of implementation (with formula, etc). I started to build it up new and I think there is a much easier way:
    http://uploaded.to/file/bmsjpv

    I proceded the following steps (find modifications in bold):
    1. Bind labels of the selector (eg. B2:B5)
    2. Set Insertion type and destination (eg. C2)
    3. Set the selected item type on Dynamic on the behaviour tab of the selector
    4. Bind the item to a cell (eg C2)
    5. Bind source cell of Push button (eg. D2) – this is the default value
    6. Bind destination cell of Push button (eg. C2, same as selected item of combo!)

    Is there anything I didn’t considered with this way of implementation?

    Cheers
    DoubleM