Representing each bar of a stacked in % of its total

[#1]

Hi guys,

i've been out of the QlikView game for a while but back into the swing of things..

I was wondering if anyone can help me out with a bar chart I need to create.

I have a query that returns transaction information and categorises it as 'Utilised' or 'Un-Utilised'

The chart has two dimensions, region and utilisation

(see attached qvw)

I want to represent the each region as 100% of that region's actual hours (stacked showing utilisation adding up to 100%)

how can I acheieve this?

thanks in advance,

Matt

[swuehl]

Maybe using:

=Sum(ACTUAL_HOURS)/SUM(total<RESOURCE_REGION> ACTUAL_HOURS)

Regards,

Stefan

[#3 · Accepted solution]

... or  this

=sum(ACTUAL_HOURS)/rangesum(top(sum(ACTUAL_HOURS),1,noofrows()))

JJ