Bar-Chart with 100% for each Bar

markmm — Mon, 20 Feb 2012 15:40:22 GMT

Hi all

I'v already posted my problem last week. It's possible that the attached excel-chart isn't buildable in QlikView? The challenge is to have for each bar 100% and values in number and not in %

Thanks for your help

Re: Bar-Chart with 100% for each Bar

swuehl — Mon, 20 Feb 2012 17:40:25 GMT

Try this:

Use a crosstable load to convert your crosstable data in to a straight table:

INPUT:

CROSSTABLE (Type, Value) LOAD * INLINE [

Produkt, vollständig, unvollständig

A, 105, 31

B, 437, 201

C, 123, 23

D, 49,24

E, 342, 222

F, 1034, 0

];

Then create a bar chart with dimension Produkt and Type and as expression

=sum(Value) / sum(total<Produkt> Value)

and use a stacked bar style from style tab.

Hope this helps,

Stefan

edit:

add a second expression

sum(Value)

with display option only 'values on data points' (bar deselected) and in presentation tab select 'plot values inside data segments' to show the Values in the bars.

Set number format in number tab for both expressions accordingly (see also attachment).

Bar-Chart with 100% for each Bar

markmm — Mon, 20 Feb 2012 19:51:40 GMT

great solution, thanks

topic Bar-Chart with 100% for each Bar in QlikView

Bar-Chart with 100% for each Bar

Re: Bar-Chart with 100% for each Bar

Bar-Chart with 100% for each Bar