Qlik Community

Ask a Question

New to QlikView

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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

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

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.