How to display pre-aggregated data in hierarchy

Fri, 09 Aug 2013 00:28:01 GMT

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!

Re: How to display pre-aggregated data in hierarchy

Gysbert_Wassenaar — Sat, 10 Aug 2013 18:52:45 GMT

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().

topic How to display pre-aggregated data in hierarchy in QlikView

How to display pre-aggregated data in hierarchy

Re: How to display pre-aggregated data in hierarchy