topic Re: Parent/Child Service Request Layout in QlikView

Parent/Child Service Request Layout

lukegilligan — Sat, 24 Jun 2017 01:20:19 GMT

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?

Re: Parent/Child Service Request Layout

ahaahaaha — Sat, 24 Jun 2017 05:28:56 GMT

Hi,

May be like in attached file.

Regards,

Andrey

Re: Parent/Child Service Request Layout

MarcoWedel — Sat, 24 Jun 2017 22:26:33 GMT

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

Re: Parent/Child Service Request Layout

lukegilligan — Tue, 27 Jun 2017 00:18:17 GMT

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.

Re: Parent/Child Service Request Layout

MarcoWedel — Tue, 27 Jun 2017 22:39:09 GMT

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