How to display pre-aggregated data in hierarchy

[#1]

My datasource is already pre-aggregated.

Example:

Global 500(preaggregated from children A and B)

  --Child_A 300

  --Child_B 200(preaggregated from grandchildren B1 and B2)

     --grandchild_B1 150

     --grandchild_B2  50

As you can see, there will be double counting, if Qlikview hierarchy aggregates at global and Child_B level again.

When i build a hierarchy in Qlikview, can i disable the aggregation and just display the pre-aggregated data?

Many thanks for your help!

[Gysbert_Wassenaar]

An expression is always an aggregation. If you want to show the preaggregated values then simply add that field as a dimension to a chart/table. Or you can try using the only() aggregation function in the expression instead of sum().