Skip to Content
author's profile photo Former Member
Former Member

Xcelsius drill down problem.

Hi gurus, I'm developing drill down chart and table.

I want to reset, making cell blank, the drill down cell when i click combo box.

I used push button to refresh or reset drill down value but it can not refresh(reset) drill down cell

because the destination cell of the chart remains drill down value

I tried like below way

*Dashboard explanation

this dashboard consists of one chart, one table, one combo box and one push button.

Of course, chart has the drill down function

  • a : drill down value

  • Goal : make drill down cell turn to blank after i used drill down once.


when i click the chart and use drii down, a is entered into drill down cell


by using "push button", i tried to reset drill down cell

but unfortunately it does not work.

Although drill down cell changes instantly to blank after just one second, it changes to a, drill down value

Drill down cell changes like this

1 -> 2 -> 3

a -> blank -> a

i have to eliminate (2->3) phase or find another way to refresh drill down cell.

I think problem is the chart which remains drill down value(a) although pushbutton reset the drill down cell to blank.

Is there any way to refresh or reset drill down value when i click combo box?

Should i develop custom-component? i'm waiting for your answer.

Thanks in advance.



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Oct 14, 2011 at 03:45 PM

    Hi Kwon,

    Xcelsius components does not clear the previous selection and its by design. It would work if you use RESET button, as it would reset the components. The Push button would just replace the source data for the chart, not reset the component to clear the previous selection.

    You can consider creating a custom chart to clear the previous selection.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member


      Can you confirm if what you're saying also holds for components with the "Enable Drill Down" option enabled, and the "Default Selection" is set to "No Selection (-1)"?

      I'm running into an issue where the "Default Selection" value is not cleared out after performing 3 levels of drill-down. On the third time I do a drill-down, by default the first element is selected, even though I've set the "Default Selection" to "No Selection (-1)".


  • author's profile photo Former Member
    Former Member
    Posted on May 14, 2015 at 10:09 AM

    This is by design but there should a workaround for issues in which internal memories are involved.

    I use the easiest way of releasing the memory held in the component by purging it.

    For this I use an extra empty query to clear data, and then add the actual data source into it again.

    I havent tried with Drill down but pretty sure, if you clear the memory of the component and reload it, then it will once again default to no selected value

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.