topic Re: Want to create a combo chart with grouping. in QlikView

Want to create a combo chart with grouping.

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Below is my data set.

X	Y	Product	Sum of Value
X1	Y1	P1	1
X1	Y1	P10	9
X1	Y1	P2	6
X1	Y1	P3	3
X1	Y1	P4	5
X1	Y1	P5	7
X1	Y1	P6	3
X1	Y1	P7	5
X1	Y1	P8	7
X1	Y1	P9	8
X2	Y2	P1	8.8
X2	Y2	P10	14.36363636
X2	Y2	P11	14.98181818
X2	Y2	P12	15.6
X2	Y2	P13	16.21818182
X2	Y2	P14	16.83636364
X2	Y2	P15	17.45454545
X2	Y2	P2	9.418181818
X2	Y2	P3	10.03636364
X2	Y2	P4	10.65454545
X2	Y2	P5	11.27272727
X2	Y2	P6	11.89090909
X2	Y2	P7	12.50909091
X2	Y2	P8	13.12727273
X2	Y2	P9	13.74545455
X3	Y3	P1	18.07272727
X3	Y3	P10	23.63636364
X3	Y3	P11	24.25454545
X3	Y3	P12	24.87272727
X3	Y3	P13	25.49090909
X3	Y3	P14	26.10909091
X3	Y3	P15	26.72727273
X3	Y3	P2	18.69090909
X3	Y3	P3	19.30909091
X3	Y3	P4	19.92727273
X3	Y3	P5	20.54545455
X3	Y3	P6	21.16363636
X3	Y3	P7	21.78181818
X3	Y3	P8	22.4
X3	Y3	P9	23.01818182
X4	Y4	P1	27.34545455
X4	Y4	P2	27.96363636
X4	Y4	P3	28.58181818
X4	Y4	P4	29.2
X4	Y4	P5	29.81818182
X4	Y4	P6	30.43636364
X4	Y4	P7	31.05454545
X4	Y4	P8	31.67272727
X4	Y4	P9	32.29090909

And I want to create a graph like attached image.

Can someone help me to figure out, how to do it.

Thanks & Regards,

Juthika

Re: Want to create a combo chart with grouping.

swuehl — Tue, 12 Apr 2016 23:16:15 GMT

Maybe like this?

Just create a combined dimension

LOAD X & Y as Dim,

Product,

[Sum of Value]

FROM

[https://community.qlik.com/thread/213058]

(html, codepage is 1252, embedded labels, table is @1);

Then a combochart with dimensions Dim and Product and expression =Sum( [Sum of Value])

Re: Want to create a combo chart with grouping.

Tue, 12 Apr 2016 23:18:35 GMT

I am getting the value from excel sheet

Re: Want to create a combo chart with grouping.

Tue, 12 Apr 2016 23:39:17 GMT

How to put Dim and Product as dimension. And comm213058.qvw is black for me if i open in qliksense desktop

Re: Want to create a combo chart with grouping.

swuehl — Wed, 13 Apr 2016 00:00:24 GMT

Well, you have posted this question in place New to QlikView, so I assumed that you are using QlikView.

I don't think that the combo chart in QS is supporting multiple dimensions.

Re: Want to create a combo chart with grouping.

Wed, 13 Apr 2016 16:31:27 GMT

Then how get the products. Where did you specify?

Re: Want to create a combo chart with grouping.

Wed, 13 Apr 2016 16:34:12 GMT

And how do I group mulitple XY values like below

X1Y1, X2Y2 -> group1

X1Y1, X1Y2 -> group2

X2Y1, X2Y2 -> group3

X3Y1, X2Y2 -> group3

X3Y3, X3Y2 -> group3

Re: Want to create a combo chart with grouping.

swuehl — Wed, 13 Apr 2016 16:51:42 GMT

You could use a MAPPING approach like

MAP:

MAPPING LOAD * INLINE [

F1, F2

X1Y1, group1

X2Y2, group1

X2Y1, group2

X2Y2, group2

...

];

LOAD X, Y, Product, [Sum of Value],

X&Y as Group1,

ApplyMap('MAP', X&Y, 'no map found') as Group2

FROM YourExcelTable;

Re: Want to create a combo chart with grouping.

Wed, 13 Apr 2016 19:03:52 GMT

Thank you that helped.

But I did not understand, in your graph, u put the dimension as XY and measure as sum(sum of value). How did products came. I can do in bar chart but not able to do as you gave done.

Re: Want to create a combo chart with grouping.

swuehl — Wed, 13 Apr 2016 20:42:58 GMT

In my QlikView sample file, I've used two dimensions, one of the dimensions being Product.

As I said, I don't think that is possible with a standard QlikSense combo chart, maybe you can search an extension that supports this.

Re: Want to create a combo chart with grouping.

Fri, 15 Apr 2016 18:29:41 GMT

I tried out few extensions. Thank you for your suggestions