topic Re: Multi Dimension chart in Integration, Extension & APIs

Multi Dimension chart

Anonymous — Fri, 09 Feb 2018 18:05:19 GMT

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_s3 — Fri, 09 Feb 2018 18:53:38 GMT

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

Anonymous — Fri, 09 Feb 2018 18:58:08 GMT

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_s3 — Fri, 09 Feb 2018 19:44:23 GMT

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.

Re: Multi Dimension chart

Anonymous — Fri, 09 Feb 2018 20:05:41 GMT

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