Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

D3Dynamic Tree Layout Extension

Hi Everyone,

               I am using D3Dynamic Tree Layout Extension ,I have created hierarchy based on Designation.I want to show Count of employees in each level based on Designation.

Please find the attached file.

Any Suggestions would  be greatly appreciated.

Regards,

P.Divya

10 Replies
vishsaggi
Champion III
Champion III

May be you can try ?

In a Bar chart

Dimension: Designation or Empname (Which describes the designation)

Expr: Count(EmpID)

qliksus
Specialist II
Specialist II

hi

Are expecting something  like this in chart ?

Not applicable
Author

Hi ,

    Thanks for quick response.I am expecting in D3Dynamic Tree Extension not in chart.

Regards,

P.Divya

vishsaggi
Champion III
Champion III

Hello Divya,

Can you post us expected output and in which tab you are referring to ?

Thanks,
V.

adamdavi3s
Master
Master

Hi,

I've tried various formula in the standard data but obviously the extension will only display the data for that point.

I think you somehow need to calculate the number of employees that the manager has and load this as a field, which you can then use this in the 'measure' column.

Shouldn't be that tricky to do

Not applicable
Author

see this:

adamdavi3s
Master
Master

Something sort of like this, but currently this will only give you direct reports, not a full count of the employees underneath, sorry its monday and my brain isn't fully up to speed yet

adamdavi3s
Master
Master

Ok this is a really dirty example, but you should be able to improve it for your needs!

Not applicable
Author

Hi ,

  Thanks to everyone for quick response.I want to show count of employees in each level based on designation .

Please find the attached file.I  am getting same count in TL level .I want to show count of TLs to the respective Asst Manager.

Thanks & Regards,

P.Divya