Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Working with hierarchies

Hi

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:

jerar5.png

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

jerar3.png

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.

3 Replies
Highlighted
Not applicable

Re: Working with hierarchies

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

Highlighted
Not applicable

Re: Working with hierarchies

thanks

Highlighted
Not applicable

Re: Working with hierarchies

Did you manage to get this working?