topic Re: Working with hierarchies in QlikView

Working with hierarchies

Anonymous — Sat, 16 May 2015 14:58:13 GMT

Hi,

I have created a hierarchie (geo type) in Qlickview:

This is the file:

ans this is the script:

Jerarquia_pais:

Hierarchy(cod_geo, cod_padre, desc_geo, desc_padre, desc_geo, jerarquia_geografica , '|', profundidad) LOAD

cod_geo,

cod_padre,

desc_geo

FROM

(ooxml, embedded labels, table is Hoja1);

Now I have a listbox with the hierarchie working properly:

the fact table is at low level of the hierarchie (ciudad).

My question:

Now I can only select in the listbox al the low level (ciudad), is there anyway of selectiong at a higer level (pais)?, and filtering that rows in the chart (see only data of this selected level)?

for examploe: select España and see data of: Madrid, Sevilla, Valencia, Zaragoza...

Thanks in advance.

Re: Working with hierarchies

Gysbert_Wassenaar — Sat, 16 May 2015 15:28:59 GMT

I think you're looking for the HierarchyBelongsTo function instead of the Hierarchy function. You can find an explanation in this blog post: Unbalanced, n-level hierarchies

Re: Working with hierarchies

Anonymous — Sat, 16 May 2015 18:00:37 GMT

Thanks Gyspert,

Now I have created a HierarchyBelongsto.

Jerarquia_pais2:

HierarchyBelongsto (cod_geo, cod_padre, desc_geo, cod_padre, desc_padre, nivel)

LOAD

cod_geo,

cod_padre,

desc_geo

FROM

(ooxml, embedded labels, table is Hoja1);

My problem now: how can I make a listbox od treeview typw with this hierarchy??

I needd, something like:

Thanks in advance!!

Re: Working with hierarchies

petter — Sat, 16 May 2015 21:41:39 GMT

Here is a clipping from Henric Cronström's excellent article about Hierarchies‌

that shows probably what you are looking for. You need to have a Path with some kind of separator which you can specify - like for instance a /

Re: Working with hierarchies

Gysbert_Wassenaar — Sun, 17 May 2015 06:06:52 GMT

You can link your Jerarquia_pais2 hierarchybelongsto table with another table created with the hierarchy function. See the Treebridge and Trees table in the attached example. The Trees table contains a Treepath field that is used in a listbox to select a district. In the pivot table this district and the underlying districts are shown.

Note, there's also a way to select entire subtrees without a hierarchybelongsto table. First collapse the parent of the subtree you want to select and then select the parent node of that subtree. If you then expand it you'll see that the nodes below it are also selected. If you expand the node first and then select it only the node itself will be selected.