2 Replies Latest reply: Jul 10, 2013 8:08 AM by Rainer Filoda RSS

    Help on hierarchy problem

      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