topic Re: Unbalanced hierarchy and Pivot Table in App Development

Unbalanced hierarchy and Pivot Table

SimoneMas — Mon, 20 Dec 2021 21:32:42 GMT

I have a problem with an unbalanced hierarchy and its display with Pivot table.

I have two tables (sales and geo):
the first is the sales table made up of
id_geo
month
amount

the second is the table with the hierarchy
id_geo
id_parent
id_geo

the data are as follows

id_geo	id_parent	name_geo
1		Europe
2	1	France
3	1	Italy
4	3	Lazio
5	3	Lombardia

id_geo	month	amount
5	1	100
5	2	120
4	1	80
4	2	130
2	1	350
2	2	600

in Qlik I load the two tables in the following way

[geo]:
Hierarchy ([id_geo], [id_parent], [name_geo], [ParentName], [PathSource], [PathName], [PathDelimiter], [Depth])
SELECT [id_geo],[id_parent],[name_geo] FROM geo;

[sales]:
SELECT [id_geo],month,amount FROM sales;

when I create the pivot table I get the following result

how do I delete the "+" or "-" symbol for the France value? (France has no children unlike Italy) I tried different ways (hide empty lines, hide if, HierarchyBelongsTo instead of Hierarchy) but without success.

Thank you

Re: Unbalanced hierarchy and Pivot Table

rklaytonmb — Wed, 24 Mar 2021 14:55:35 GMT

Hi, SimoneMas

Do you get solution for it, i have the same situation

Re: Unbalanced hierarchy and Pivot Table

Renato_Gerber_Polynorm — Fri, 09 Feb 2024 07:26:52 GMT

I have the same problem. Now I think the only way is fill up the emty levels with the value from the last entry. So that the hierachy look like a balanced one. Has some one a other idea?

Re: Unbalanced hierarchy and Pivot Table

aabou — Fri, 09 May 2025 12:21:25 GMT

We’ve found a solution to the problem with unbalanced hierachy. We built the Data+ Tree Table for structured hierarchy handling.
Check out this video on YouTube https://youtu.be/reckH5zcXzM?si=uhNR5_5Jw9WyXMfe