Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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
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