Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

May be something like this:

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

View solution in original post

2 Replies
Highlighted

May be something like this:

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

View solution in original post

Highlighted
Not applicable

Thank Sunny,

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