topic Re: Bar chart - divide each bar into stacks in QlikView

Bar chart - divide each bar into stacks

phoenix — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I have this bar/line graph:

dimension -> year

bars:

expression -> counts for A, B, C, D

lines:

expression-> rates for A, B, c, D

I want to stack the bars A, B, C, D into A->x1+x2+x3, B->x1+x2+x3, c->x1+x2+x3

X-> x1,x2,x3 is another dimension, I want to break the count of A, by sub groups of dimension X.

I want to stack count({x=x1}A), count({x=x2}A), count({x=x3}A) into count(A)

Is this possible?

Thanks

Re: Bar chart - divide each bar into stacks

Digvijay_Singh — Thu, 09 Feb 2017 21:19:38 GMT

Can you share sample data and expected output, if I understand correctly you want to stack your count value bars for your second dimension. Sample data and image of expected output with reference to your data will help to understand better.

Re: Bar chart - divide each bar into stacks

vishsaggi — Thu, 09 Feb 2017 21:44:23 GMT

Did you try these? If not can you share a sample app?

Re: Bar chart - divide each bar into stacks

phoenix — Thu, 09 Feb 2017 22:07:05 GMT

Re: Bar chart - divide each bar into stacks

phoenix — Thu, 09 Feb 2017 22:09:23 GMT

below is the sample data. I am not able to attaché the app.

year	group	subgroup	accs	bad
2012	A	x1	10	1
2012	A	x2	20	3
2012	A	x3	30	3
2012	B	x1	40	7
2012	B	x2	50	7
2012	B	x3	60	9
2012	C	x1	70	5
2012	C	x2	80	8
2012	C	x3	90	2
2012	D	x1	100	4
2012	D	x2	110	11
2012	D	x3	120	8
2013	A	x1	130	9
2013	A	x2	140	4
2013	A	x3	150	3
2013	B	x1	160	16
2013	B	x2	170	12
2013	B	x3	180	18
2013	C	x1	190	11
2013	C	x2	200	54
2013	C	x3	210	45
2013	D	x1	220	8
2013	D	x2	230	23
2013	D	x3	240	4
2014	A	x1	250	67
2014	A	x2	260	26
2014	A	x3	270	34
2014	B	x1	280	28
2014	B	x2	290	65
2014	B	x3	300	30
2014	C	x1	310	67
2014	C	x2	320	32
2014	C	x3	330	88
2014	D	x1	340	34
2014	D	x2	350	35
2014	D	x3	360	36
2015	A	x1	370	87
2015	A	x2	380	38
2015	A	x3	390	39
2015	B	x1	400	40
2015	B	x2	410	47
2015	B	x3	420	54
2015	C	x1	430	89
2015	C	x2	440	44
2015	C	x3	450	56
2015	D	x1	460	46
2015	D	x2	470	47
2015	D	x3	480	48