Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead 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
sunny_talwar

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
sunny_talwar

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

Not applicable

Thank Sunny,

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