Calculating a percentage base vs chart, with only 2 of 3 values of a dimension

[#1]

Hi i'm new to Qlikview so some of my lingo might be a bit off.

I have a bar chart grouped in a stacked fashion with two dimensions.My expression is as follows. Count(DimesionA)/count(Total<DimensionB> DimensionA). Which gives me the Sample Graph i attached.''

What i would like to achieve in a different graph having lets says the green vs red values of each bar separately. Taking the example :

66.4% - 10.7% = 55.7%

65.0% - 12.4% = 52.6% .. and so on

The end result will a a bar with 55.7% value, a second one with 52.% value, ... and so on.

Regards.

[sunny_talwar · Accepted solution]

May be something like this:

(Count({<DimensionA = {'Green'}>}DimesionA)/count(Total<DimensionB> DimensionA)) -
(Count({<DimensionA = {'Red'}>}DimesionA)/count(Total<DimensionB> DimensionA))

[#3]

Thank Sunny,

Very helpful, i used your expression and it worked great.