Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

how to select two dimension on one click

Hello All,

Is it possible to select two values of two different dimension on one click.......what i mean is

i have a bar chart with 2 dim 1)primary dim:material

                                          2)secondary dim:decision

and i wrote trigger on first dim(material) so that on click bar chart axis it should bring me to next sheet ...which is working fine

what i am looking for is on the click i need the second dim should also be selected.........it mean in next sheet i should see only the selected material and its selected decision ...is it possible

thanks

naveen

6 Replies
swuehl
MVP
MVP

If you make a selection in a bar chart, you are not selecting the bar, but the underlying dimension, and AFAIR, if you are using two dimensions, you will first select on the first dimension, then on a second click on a segment / bar the second.

Hence, the time you fire your trigger, there is no information in the selection state that you clicked on a specific value in first and second dimension.

If you need both informations, I think you need to let the user make a second selection on second dimension, then create a trigger that checks that boths fields have selections in an open your other tab.

Hope this helps,

Stefan

kunkumnaveen
Specialist
Specialist
Author

HI,what exactly i need to do now ?do i need to write trigger on second dimension ?

can you elaborate a bit more plz,,,currently i wrote trigger on first dimension ...........

Kushal_Chawda

Hi Navin,

As swuehl‌ said, First you select the Primary dimension value in chart, then let user to select the values of secondary dimension values as well. Now you can set the trigger on secondary dimension to go to next sheet so that both the dimension values will be selected on next sheet

kunkumnaveen
Specialist
Specialist
Author

Hello Kush

First you select the Primary dimension value in chart



how to do this?

Kushal_Chawda

Either you use trigger or do the normal selection

jharke
Creator
Creator