Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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).
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).
great solution, thanks