Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
... or this
=sum(ACTUAL_HOURS)/rangesum(top(sum(ACTUAL_HOURS),1,noofrows()))
JJ
Maybe using:
=Sum(ACTUAL_HOURS)/SUM(total<RESOURCE_REGION> ACTUAL_HOURS)
Regards,
Stefan
... or this
=sum(ACTUAL_HOURS)/rangesum(top(sum(ACTUAL_HOURS),1,noofrows()))
JJ