Discussion board where members can get started with Qlik Sense.
I have a Hierarchy with Territory,Division,Product Line,Business Unit.
I want to get the aggregated total at each Level.
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?
Are you using pivot table ?
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
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