topic How to organize data to get hiearchy details in QlikView https://community.qlik.com/t5/QlikView/How-to-organize-data-to-get-hiearchy-details/m-p/53446#M767546 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We have jobs and its start time and end time. Every job has its dependent (parent job) and dependent job (parent job) has its start time and end time.</P><P>we need to find out job and its immediate dependent jobs (one by one)</P><P></P><P>So I am trying to create data in such a way so that I can do drill in QlikView.</P><P></P><P>LPUL1 has parent job LPUL2 and then LPUL2 has parent job LPUL3 . like wise.</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/205714_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Please let me know if this approach is correct or do I need to organize data in different way to get drilling work in QlikView.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT ashis 2020-11-25T16:16:04Z How to organize data to get hiearchy details https://community.qlik.com/t5/QlikView/How-to-organize-data-to-get-hiearchy-details/m-p/53446#M767546 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We have jobs and its start time and end time. Every job has its dependent (parent job) and dependent job (parent job) has its start time and end time.</P><P>we need to find out job and its immediate dependent jobs (one by one)</P><P></P><P>So I am trying to create data in such a way so that I can do drill in QlikView.</P><P></P><P>LPUL1 has parent job LPUL2 and then LPUL2 has parent job LPUL3 . like wise.</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/205714_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Please let me know if this approach is correct or do I need to organize data in different way to get drilling work in QlikView.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-organize-data-to-get-hiearchy-details/m-p/53446#M767546 ashis 2020-11-25T16:16:04Z