Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

lukegilligan
New Contributor III

Parent/Child Service Request Layout

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 NumberSR SummarySR Date EnteredSR Date ClosedSR Parent
100001Maintenance Required20/06/201724/06/2017
100002Arranged site visit21/06/201721/06/2017100001
100003Attended site22/06/2017100001
100004Ordered parts22/06/201723/06/2017100003
100005Maintenance Completed24/06/201724/06/2017100001

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?

1 Solution

Accepted Solutions

Re: Parent/Child Service Request Layout

Hi,

maybe one solution might be:

QlikCommunity_Thread_265362_Pic1.JPG

QlikCommunity_Thread_265362_Pic2.JPG

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

4 Replies
ahaahaaha
Honored Contributor

Re: Parent/Child Service Request Layout

Hi,

May be like in attached file.

Regards,

Andrey

Re: Parent/Child Service Request Layout

Hi,

maybe one solution might be:

QlikCommunity_Thread_265362_Pic1.JPG

QlikCommunity_Thread_265362_Pic2.JPG

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
New Contributor III

Re: Parent/Child Service Request Layout

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

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

Community Browser