Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be something like this:
(Count({<DimensionA = {'Green'}>}DimesionA)/count(Total<DimensionB> DimensionA)) -
(Count({<DimensionA = {'Red'}>}DimesionA)/count(Total<DimensionB> DimensionA))
May be something like this:
(Count({<DimensionA = {'Green'}>}DimesionA)/count(Total<DimensionB> DimensionA)) -
(Count({<DimensionA = {'Red'}>}DimesionA)/count(Total<DimensionB> DimensionA))
Thank Sunny,
Very helpful, i used your expression and it worked great.