Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Partner - Creator II
Partner - Creator II

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
Not applicable
Author

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
Partner - Creator II
Partner - Creator II

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
Not applicable
Author

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