3 Replies Latest reply: Jul 27, 2017 6:39 AM by Vinayak Bhatt RSS

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

    Vinayak Bhatt

      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

        • Re: is the are way to create drop down box to change dimesions for x axis
          omar bensalem

          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?

            • Re: is the are way to create drop down box to change dimesions for x axis
              Vinayak Bhatt

              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

            • Re: is the are way to create drop down box to change dimesions for x axis
              omar bensalem

              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 :

              Capture.PNG



              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)

              Capture.PNG

               

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

              Capture.PNG

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


              Capture.PNG


              Title:

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

              Capture.PNG



              Result :

              Capture.PNG

              Capture.PNG




              Capture.PNG



              etc !

              Hope this helps