Hierarchy Question

[Joaquin_Lazaro]

Hello:

In this qvw I've created a Hierarchy table, and I show a list box with the path and two aditional expresions.

I want the list box show de sum  of the nodes for the parents lines, but I don't know how to do it.

Please, can somebody help me?

Thank you,

Joaquín

[#2]

Joaquin,

i had published a doc on that topic: http://community.qlik.com/docs/DOC-4823

There is also a very good document by HIC on the hierarchies: http://community.qlik.com/docs/DOC-5334

Fabrice

[hic · Accepted solution]

You should create a pivot table with SZTITLE1 ... SZTITLE4 as dimensions. Sum(NPR) and Sum(NCO) as expressions. (Style: Indent Mode)

HIC

[Joaquin_Lazaro]

Thank you Aunez for this excelent documents.

[Joaquin_Lazaro]

Thanks for your help, Henric.

I've created a pivot table, but this chart shows all the "inexistent" nodes of hierarchy levels 3 & 4.

Is possible show only levels with related info on expresions?

If I check "delete when null values" on dimension 4, the chart don't show the upper hierarchy (include SZTITLE).

[hic]

If you have a number associated with a node on level 2, then of course level 3 and 4 will be shown as NULL. If you expand the NULL node, then you will get one row with the value for the NULL node, and one row as the partial sum. So - don't expand the NULL nodes.

In your data, you have one row where SZTITLE2='Maqinaria para tampgrafia' with an NCO=3 and NPR=30. SZTITLE3 and SZTITLE4 are both NULL on this row. You do not want to hide this row, so you should not "Suppress when value is NULL". And you do not want to show both the node and the partial sum so you should not expand it.

HIC

[Joaquin_Lazaro]

OK. Thank you.