Working with hierarchies

Anonymous — Thu, 21 May 2015 12:23:04 GMT

I have created a hierarchie like that:

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); Hoja1);

My source date are:

then I make a treeview in a listbox that allow me to select values makinf drll-down in the hierarchie:

My question is:

I have a chart of sales using a typical sales fact table. That chart has members of this hierarchie as dimension. I would like to select the dimension in the chart and doing drill-down if there is a lower level in the hierarchie (for example: Europe -> Spain -> Madrid).

That is to use the hierarchie in the selecctions in my chart.

Is that posiible using my hierarchie table linked with the fact sales table.

I know that I can make a hierarchical group, but it is not simple for this hierarchie and I prefer to use the hierarchie table.

Thanks in advance.

Re: Working with hierarchies

Thu, 21 May 2015 15:49:14 GMT

Hi,

If you link your sales fact table to your hierarchy using the cod_geo field you can then use field desc_geo1,desc_geo2,desc_geo3… in your drill down group dimension

Re: Working with hierarchies

Mon, 25 May 2015 05:45:13 GMT

thanks

Re: Working with hierarchies

Thu, 13 Oct 2016 09:02:25 GMT

Did you manage to get this working?

topic Re: Working with hierarchies in QlikView

Working with hierarchies

Re: Working with hierarchies

Re: Working with hierarchies

Re: Working with hierarchies