I have a hierarchical structure/table like: ( '||' separates the levels )
Object_Name || Aspect_Name | Aspect_Weight || Detail_Name | Detail_Weight || Rating
and data in QlikView.
Objects have several aspects with their weights, which have several details with a weight, the details have a rating.
A single value shall be calculated for every object, bottom up, by weighted sums:
Result_Object = SUM (Aspect_Weight * Result_Aspect) and Result_Aspect = SUM ( Detail_Weight * Rating )
My task is to calculate the results and write them to separate fields like:
<table above> | Result_Object | Result_Aspect | Result_Detail
So far I didn't manage to pass a result of a weighted sum to the 'dynamic update'-function, which was my first intention. My second try was to do the calculations iteratively in a macro, but here I don't know how to obtain the right relations between the objects their aspects and details.
Anyone got an idea? Thank you!