topic Messing around with a Hierarchy in QlikView

Messing around with a Hierarchy

Anonymous — Wed, 27 May 2015 11:22:38 GMT

Hi,

i've got this table:

What i want to implement: When a user clicks on 'Workcenter 1', it should select all attendance Values but only '5000' from the output column.

Can somebody help me? Can i do this with a flag?

jonathandienst — Wed, 27 May 2015 11:24:48 GMT

In a straight table with dimension [Work Centre], use the following expressions:

Sum(TOTAL Attendance)

Sum(Output)

Anonymous — Wed, 27 May 2015 12:01:01 GMT

Jonathan,

this would work, but in most cases all attendance and all output values are needed.

let me know if my question is a bit unclear.

Edit:
What i want to accomplish:

KPI = Output / Attendance

In some WorkCenter groups this formula is a bit modified.

Lets say we've got the Workcenter "Electroplating". This Workcenter has some subgroups.
But for this formula its not:

Output from all subgroups / Attendance from all subgroups

but instead it is:

Output from one subgroup / Attendance from all subgroups

I hope this makes it clearer