topic Hierarchy and related data in QlikView https://community.qlik.com/t5/QlikView/Hierarchy-and-related-data/m-p/219577#M72588 <HTML><HEAD></HEAD><BODY><P>Hi to all,</P><P>I have a sales structure of:</P><P>District Manager</P><P>Area Manager</P><P>Sales Reps</P><P>Area</P><P>i.e DM = Tom</P><P>AM = Barry, Frank, Alex</P><P>PS of Barry = Louis, Angel</P><P>PS of Frank = Kate, Ann</P><P>Area of Kate = 'LA 555', 'SF 444', 'SC 123'</P><P>I build my hierarchy that's work perfcetly but now i have to connect the Customers to the different Reps. The connection is done by the Area field. I defined the Area as CategoryID and I get no errors but I'm unable to see the customers related to my hierarchy and additional data. Is the problem related to the text type of the filed Area?</P><P>Thanks for any help!</P><P></P></BODY></HTML> Mon, 19 Oct 2009 22:43:10 GMT 2009-10-19T22:43:10Z Hierarchy and related data https://community.qlik.com/t5/QlikView/Hierarchy-and-related-data/m-p/219577#M72588 <HTML><HEAD></HEAD><BODY><P>Hi to all,</P><P>I have a sales structure of:</P><P>District Manager</P><P>Area Manager</P><P>Sales Reps</P><P>Area</P><P>i.e DM = Tom</P><P>AM = Barry, Frank, Alex</P><P>PS of Barry = Louis, Angel</P><P>PS of Frank = Kate, Ann</P><P>Area of Kate = 'LA 555', 'SF 444', 'SC 123'</P><P>I build my hierarchy that's work perfcetly but now i have to connect the Customers to the different Reps. The connection is done by the Area field. I defined the Area as CategoryID and I get no errors but I'm unable to see the customers related to my hierarchy and additional data. Is the problem related to the text type of the filed Area?</P><P>Thanks for any help!</P><P></P></BODY></HTML> Mon, 19 Oct 2009 22:43:10 GMT https://community.qlik.com/t5/QlikView/Hierarchy-and-related-data/m-p/219577#M72588 2009-10-19T22:43:10Z