Hierarchy issue

[imhappiee]

Hi,

I have table as attached in the screen shot and with with I created a table  from source table to get the hierarchy

till to this extent i was good

but after this I was unable to bridge the hierarchy and the source table to get the values grouped up at hierarchy level

any help on this will be highly appreciated.

Kind Regards,

Anand.

[Gysbert_Wassenaar]

Please post a qlikview document that demonstrates the problem.

[imhappiee]

Ho Gysbert

I have attached the qvw to the main post , please help me out.

regards,

Anand.

[#4]

Hello Anand,

Have you checked out this technical brief on hierarchies by hic‌

Hierarchies‌

Not sure but think your problem may be happening because some supervisor ids do not exist in the employee id field.

[Gysbert_Wassenaar]

See attached qvw

[imhappiee]

Gysbert

To an extent this helps me but this need to be more fine tuned as the data is in the below format and i want that as mentioned in the image.

where as in the current application that u helped me with, I could see that the employee who is at level 2 is coming in level1 .

so can u fine tune it more and get the result as desired and help me face this challenge.

Regards,

Anand.

[imhappiee]

Sana,

Thanks for the post, I have gone through all this links before posting this question.unfortunately which didnt helped me much in this challenge 

Thanks

Anand.

[imhappiee]

Hi

@Jakub Michalik hic‌  @hic

Based on the following post and you valuable suggestions for it

Re: Hierarchy - how to concatenate tables with different depth nodes

I tried looping the data for a specific month and creating hierarchy as per the following code , but was unable to achieve it, could you please help me on this as well

**********************************************************************************************************

absmonth_table:

load

Distinct

     abs_month

FROM

(qvd);

LET vAbs_mnthno = NoOfRows('absmonth_table');

FOR i=0 TO $(vAbs_mnthno)-1

  LET vAbs_mnth = peek('abs_month',$(i),'absmonth_table');

  TRACE *****$(vAbs_mnth)*****;

   // load filtered (by Dim1) data from qvd

  Hrchy_temp:

  Load

           '$(vAbs_mnth)' AS abs_filter,  *

  FROM C:\Anand\Section access proj_Sales comp\QVDs\Data.QVD (qvd)

   WHERE abs_month = '$(vAbs_mnth)';

NEXT

Hrchy:

NoConcatenate

HIERARCHY(employee_id, supervisor_id, employee_name, , , , )

load *

Resident Hrchy_temp;

drop tables absmonth_table, Hrchy_temp;      

exit script;

**********************************************************************************************************************************

Quick Note:

There is a possibility of employee getting shifted to a different manager (parent) in a month,

Eg:

absmonth    emp      sup

201505      arun       Ajay

201504      arun       arvind

so i need hierarchy based on abs month and then wanted to join all the the data of different months

Thanks In advance

Regards,

Happy