Bar-Chart with 100% for each Bar

[markmm]

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

[swuehl · Accepted solution]

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).

[markmm]

great solution, thanks