Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Representing each bar of a stacked in % of its total

... or  this

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

JJ

2 Replies
MVP
MVP

Representing each bar of a stacked in % of its total

Maybe using:

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

Regards,

Stefan

Not applicable

Representing each bar of a stacked in % of its total

... or  this

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

JJ

Community Browser