topic Re: Hierarchy Question in QlikView

Hierarchy Question

Joaquin_Lazaro — Mon, 17 Feb 2014 15:36:55 GMT

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

Re: Hierarchy Question

Mon, 17 Feb 2014 16:18:54 GMT

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

Re: Hierarchy Question

hic — Mon, 17 Feb 2014 18:43:01 GMT

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

HIC

Re: Hierarchy Question

Joaquin_Lazaro — Tue, 18 Feb 2014 09:37:51 GMT

Thank you Aunez for this excelent documents.

Re: Re: Hierarchy Question

Joaquin_Lazaro — Tue, 18 Feb 2014 10:09:47 GMT

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).

Re: Re: Hierarchy Question

hic — Tue, 18 Feb 2014 10:24:15 GMT

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

Re: Re: Hierarchy Question

Joaquin_Lazaro — Tue, 18 Feb 2014 10:28:21 GMT

OK. Thank you.