Discussion board where members can get started with QlikView.
Hello, consider a column chart with the following:
Series: a, b, c
X-axis: X, Y, Z
|_a b c__a b c__a b c__
X Y Z
Looking at the following points on x-axis:
a = 5 8
b = 2 1
c = 7 3
(total = 14 12)
What I would like is the following values in chart:
a = 5/14=36% 8/12=67%
b = 2/14=14% 1/12=8%
c = 7/14=50% 3/12=25%
|_36 14 50__67 8 25__........
The numeric values is from count(value), so im not sure what the rest of the division should be.
Something like count(value) / [count(value) for all series on that one point on x-axis]
Go to Solution.
Try like this,
=Count(Value) / Count(total <X-axis Dimension> Value)
Can you post a sample?
Hope it helps
I have already tried that without luck.
That worked as a charm! Do you mind explain what <....> does?
It calculate individual total values in dimension..For example:
X total-> 5+2+7 = 14 Y total -> 8+1+3 = 12
Hope you understand the concept.