Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Representing each bar of a stacked in % of its total

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

1 Solution

Accepted Solutions
Not applicable
Author

... or  this

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

JJ

View solution in original post

2 Replies
swuehl
MVP
MVP

Maybe using:

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

Regards,

Stefan

Not applicable
Author

... or  this

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

JJ