# New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for
Did you mean:
Not applicable

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

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.

1 Solution

Accepted Solutions
MVP

May be something like this:

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

2 Replies
MVP

May be something like this:

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

Not applicable

Thank Sunny,