Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
trdandamudi
Master II
Master II

Can you make a default selection in drill down

I have a variable vType and the value is 'Y'. In my bar chart I have a drill down button with 4 levels like Level 1, Level 2, Level 3, Level 4. What I want is when the dash board open, in this particular chart I need the default to be Level 2 instead of 1. Can this be done ?

DR

7 Replies
Siva_Sankar
Master II
Master II

Thirumala.

Not sure whether there is any straight way. What I will do is I will make the Level2 selection and create a bookmark at this point. Then create a document trigger to apply bookmark on open. This will achieve the requirement. find the attached testing example in that I created a bookmark to lock DIM2 as default selection.

vardhancse
Specialist III
Specialist III

Hi,

In the listbox->select Level 2 ->Properties->General->Always one selected value.

so that all the time the level will be level 2

trdandamudi
Master II
Master II
Author

Thanks for the quick reply. I am aware of the bookmark technique but I am looking for more straight forward and simple solution. Because this chart will be on the server and we are having issue with bookmarks.

Thanks

RD

trdandamudi
Master II
Master II
Author

Sasi,

The question is not about list box and it is for drill down.

Thanks

DR

vardhancse
Specialist III
Specialist III

Hi,

1)

For default selection in only one chart, create one alternate state.

Assign the alternate state to the required chart.

if the level2 was coming from any field, then create one list box select Level 2 ->Properties->General->Always one selected value.

Once done the selection will pass only to the chart having same alternate state. Once if you can see the selection was passing now you can delete the list box.

2)

In chart expression, you can define the level 2 in the condition

Siva_Sankar
Master II
Master II

Thirumala,

Check whether the doc is helpful for you Set the active field in a cyclic group.qvw

trdandamudi
Master II
Master II
Author

I did looked at this one few minutes back and for some reason, I feel I cannot apply this to my issue,

Thanks

RD