Multi Dimension chart

[Anonymous]

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

[siddharth_s3]

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?

[Anonymous]

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

[siddharth_s3]

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.

[Anonymous]

every thing is right, but i want to add year on x-axis too. please see the image how it has to look.