Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

karnatianusha
New Contributor

Multi Dimension chart

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

4 Replies
siddharth_s3
Contributor

Re: Multi Dimension chart

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?

karnatianusha
New Contributor

Re: Multi Dimension chart

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
Contributor

Re: Multi Dimension chart

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.

karnatianusha
New Contributor

Re: Multi Dimension chart

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