Help on hierarchy problem

Wed, 10 Jul 2013 11:07:10 GMT

Hi to all, I'm new with QlikView Desktop and I'm starting to explore the powerful features of this product.

I've the following problem:

two excel sheets AGENTI.xslx and CLIENTI.xslx

AGENTI.xslx contains two columns:

IDAG (contains the unique identifier for an agent)

IDAGFATHER (contains the unique identifier for the chief of the agent, if null the agent is on the top of the hierarchy )

CLIENTI.xslsx contains three columns

IDCLI (contains the unique identifier for the customer)

RAGSOC (contains a description)

IDAG (contains the id of the agent rseponsible for the customer)

I'd like to create a QlikView document that allow to perform the following operations:

1 If a choose an agent (for instance A6) I want to know all customer that have A6 as responsible (so in my excel must be displayed IDCLI = 2,3)

2 If a choose an agent and thick on a checkbox (or some other idea) I want to know all customer that have A6 as responsible or a child of A6 in the hierarchy(so in my excel must be displayed IDCLI = 2, 3, 4,5,6,10,11) because 2 and 3 are related to A6, 4 and 5 related to A7 that is a child of A6, 6 and 10 related to A8 a child of A7 and 11 related to A9 that is a child of A8.

I hope this explaination is enough, if someone needs more info get in touch with me as soon as you like.

I've attached the both files.

Thank you to all for the help.

Fabrizio

Re: Help on hierarchy problem

Gysbert_Wassenaar — Wed, 10 Jul 2013 11:49:27 GMT

See attached example.

Re: Help on hierarchy problem

Wed, 10 Jul 2013 12:08:48 GMT

Hi,

please see the attached file.

Here you will have the extra fields if you want to create a pivot table.

Good luck!

Rainer

topic Help on hierarchy problem in QlikView

Help on hierarchy problem

Re: Help on hierarchy problem

Re: Help on hierarchy problem