Unbalanced hierarchy and Pivot Table

[SimoneMas]

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

[rklaytonmb]

Hi, SimoneMas 

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

[Renato_Gerber_Polynorm · Accepted solution]

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? 

[aabou]

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