Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

imrasyed
Contributor

Hierarchy level Aggregaration

Hi Experts,

I have a Hierarchy with Territory,Division,Product Line,Business Unit.

I want to get the aggregated total at each Level.

For Example:

If I go to product Line it shd give me total of product lines ignoring territory.

can any one let me know how i can achieve?

4 Replies
agni_gold
Valued Contributor II

Re: Hierarchy level Aggregaration

Hi ,

Are you using pivot table ?

satishkurra
Valued Contributor II

Re: Hierarchy level Aggregaration

See if this helps. I'm attaching the same app built in both QV and QS

The 2nd and 3rd expression gives you the TOTAL and SUB TOTAL by Product ignoring Product Name

ALso refer this link if you need to display totals at the bottom

https://community.qlik.com/thread/200383

imrasyed
Contributor

Re: Hierarchy level Aggregaration

Yes Agnivesh

imrasyed
Contributor

Re: Hierarchy level Aggregaration

This is only for one level.

If i have Multiple levels like Business Unit and when I drop down the hierarachy to Product Line level it should display the total value ignoring the first level of hierarchy

Community Browser