is the are way to create drop down box to change dimesions for x axis

[#1]

Hi All,

I need help for

changing dimension values for my app.

1.the bar chart contains two x axis and one y axis.
2.the drop downs should change dimesions

like drop down should have options like option1,option2,option3 which should change the among themselves.
dropdown2 should have optiona,optionb,optionc which should change among themselves.

I tried that but I am not able to sperate the options using alternate dimesions.
for example my alternative dimesion options are giving me option1,option2,option3,optiona,optionb,optionc.

Also how to add values on top of the bars.

Regards,
Vinayak

[OmarBenSalem]

Let me as you a question, you want a filter for example that contains 2 values:

Value 1 and Value 2 ;

if you select Value1 , you'll have in your bar chart 3 alternative dimensions option1,2 and3

if you select Value2 , you'll have in your bar chart 3 alternative dimensions optiona,b andc

is that so?

[OmarBenSalem]

If that is the case, do as follow :

1) Create an inline table as follow:

load * inline [

Option

Option 1

Option 2

];

2)

In your bar chart :

Dimension: (call it Dim 1)

if( Option = 'Option 1', YourDimension1, YourDimensionA)

Alternative dimension : (call it Dim 2)

if(Option='Option 1', YourDimension2,YourDimensionB')

Alternative dimension : (call it Dime 3)

if(Option='Option 1',YourDimension3,YourDimensionC')

Now, as a title , do as follow:

if( Option='Option 1', 'Dim 1 =YourDimension1 Dim2=YourDimension2 Dim3=YourDimension3' ,

'Dim 1 =YourDimensionA Dim2=YourDimensionB

Dim3=YourDimensionC)

to have the values on the bar, go to aspect, presentation :

Per analogy: I want to have Value 1 and Value 2 as options.

If I select value 1 I want to have 2 alternate dimension : Region and territory code

if I select Value 2 I want to have Year and english short name as alternative dimensions

1)

2) Dimension 1 : =if(Option='Value1',[OICA region],Year)

Dimension 2: =if(Option='Value1',[Territory code],[English short name])

Title:

=if(Option='Value1', 'Dimension 1 : Région ,Dimension 2 Territory code', 'Dimension 1: Année ,Dimension 2 english short name')

Result :

etc !

Hope this helps

[#4]

HI Omar,

Thank you for your time. Actually I need to dimesions for x axis and each dimesion should have options to choose from

Like for x.Dimesion1->country,gender,profile for x.Dimesion2->a,b,c

so my dimesion should be like

count(id) which is my y axis |

                                             |_________________x.Dimesion2(a,b,c)____________________________________

                                             |

                                             |                                               |

                                             |                                              |

                                             |

                                             |______________________________________________

                                               x.Dimesion(country,gender,profile)

Regards,

Vinayak