100% Stacked bar chart

[#1]

Hi,

Does anyone know how to create a '100% stacked bar' chart in a way, that tool compares the % not to the total, but to the reported groups? I.e.: sum(Product "X")=100%

	Product "X"	Product "Y"	Product "Z"	Grand Total
Approved	1,427,075	267,717	1,189,907	2,884,699
Rejected	847,693	765,022	817,593	2,430,308

And is it possible in any way to have both, the values and the % visible in the same chart? Or at least add the values into a % bar chart? Many thanks for your help!

Message was edited by: Prakash Pawar

[#2]

Hey Prakash, can you attach a sample file if possible.

I think you can add another expression and make it text. Then you would have a bar in % and a value in text.

[MarcoWedel]

Hi Prakash,

maybe you find this solution helpful?

Chart Dimensions:

1. Product
2. Status

Chart Expression:

=sum(Value)/sum(Total<Product> Value)

The trick is to only total all chart dimension except the Product dimension, which in this case leaves only the Status dimension.

Load script:

CrossTable(Product, Value)
LOAD F1 as Status,
     [Product "X"],
     [Product "Y"],
     [Product "Z"],
     [Grand Total]
FROM
[http://community.qlik.com/thread/111482]
(html, codepage is 1252, embedded labels, table is @1);

I had to transform your table a bit (crosstable load).

Hope you don't mind

regards

Marco

[srchilukoori]

Chek the option 'values on data points' on the expression tab and also the 'Plot values inside the segments' in the presentation tab.

[MarcoWedel]

one more flexible way, using a calculated dimension that includes the rejected value:

=Product&chr(10)&num(aggr(Sum({$<Status={'Rejected'}>}Value), Product), '#,##0')

regards

Marco

[MarcoWedel · Accepted solution]

or maybe this one?

regards

Marco