Parent/Child Service Request Layout

[lukegilligan]

I am dragging information out of our CRM around Service Requests and was wondering if someone could help explain how I might be able to achieve displaying the relationship between Parent/Child Service Requests.

Current I have a straight table that the SR Number ([SR Number]) and the details of the request ([SR Summary] [SR Date Entered] [SR Date Closed] & [SR Parent])

SR Number	SR Summary	SR Date Entered	SR Date Closed	SR Parent
100001	Maintenance Required	20/06/2017	24/06/2017
100002	Arranged site visit	21/06/2017	21/06/2017	100001
100003	Attended site	22/06/2017		100001
100004	Ordered parts	22/06/2017	23/06/2017	100003
100005	Maintenance Completed	24/06/2017	24/06/2017	100001

I would like to be able to display this data in a hierarchy similar to this, basically showing the child SR's underneath their parent SRs:

+ 100001 - Maintenance Required

|  - 100002 - Arranged Site Visit

|  + 100003 - Attended site

     |  100004 - Ordered Parts

|  -  100005 - Maintenance Completed

Is this possible at all?

[ahaahaaha]

Hi,

May be like in attached file.

Regards,

Andrey

[MarcoWedel · Accepted solution]

Hi,

maybe one solution might be:

table1:
Hierarchy ([SR Number],[SR Parent],[SR Summary],,[SR Number])
LOAD [SR Number],
    [SR Summary],
    [SR Date Entered],
    [SR Date Closed],
    [SR Parent]
FROM [https://community.qlik.com/thread/265362] (html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco

[lukegilligan]

Thanks Marco, this looks exactly like what I am looking for.

I presume this section is a QV function that will group the SR's?

Hierarchy ([SR Number],[SR Parent],[SR Summary],,[SR Number])

Ill try it out on my live data and let you know if it works.

Thanks again.

[MarcoWedel]

You're right, the Hierarchy prefix creates hierarchies from loaded parent/child relations.