4 Replies Latest reply: Feb 9, 2018 3:05 PM by Anusha Karnati RSS

    Multi Dimension chart

    Anusha Karnati

      Hi i would like to add 2 dimensions on my y-axis and 2 measures on my x-axis to create an area graph.But unfortunately qliksense is not allwing multi dimensions and multi measures at the same time. Can some one help whether there is an extension for this?

      Thanks

        • Re: Multi Dimension chart
          Siddharth Sheshadri

          Are you looking for a 3D chart?

          But tell us what your requirement is. Maybe there is another solution. I mean, why are you looking for such a chart?

            • Re: Multi Dimension chart
              Anusha Karnati

              i have the sales and revenue of 2 companies based on years. So ideally, i want to see sales segemented by 2 companies and also revenue segmented by 2 companies.So on x-axis,based on years i should see the 4 area graph stacked up.Please let me know in case i am not clear

                • Re: Multi Dimension chart
                  Siddharth Sheshadri

                  I am assuming you have 2 different tables which is why you need 2 dimensions?

                   

                  Concatenate both your tables in your load script.

                  Something like:

                   

                  LOAD * INLINE [ Company, Sales, SalesID, Revenue, RevenueID

                                                1, 100, aa, 200, xx

                                                1, 200, bb, 300, yy

                                                1, 300, cc, 400, zz

                                           ];

                  CONCATENATE

                   

                   

                  LOAD * INLINE [ Company, Sales, SalesID, Revenue, RevenueID

                                                2, 100, a1, 200, x1

                                                2, 200, a2, 300, x2

                                           ];

                   

                  The Keyword concatenate will merge both your source table into a single table

                   

                  Then in your graph's dimension, add "Company"

                  In your measure, add SUM(Sales) & SUM(Revenue)

                   

                  If my assumption is not right, provide a sample data model.