Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

How to display pre-aggregated data in hierarchy

My datasource is already pre-aggregated.


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!

Tags (2)
1 Reply
MVP & Luminary
MVP & Luminary

Re: How to display pre-aggregated data in hierarchy

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

talk is cheap, supply exceeds demand