Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
pls help:
table
employee id name manager id
1 sss 3
2 bbb 3
3 ddd 28
4 hhh 1
5 jjjj 1
6 uuu 1
28 hhhh 1
I want result
employee wise reporting count, means all employees and their reporting count.
employee name reporting count
1 sss 3
2 bbb 0
3 ddd 2
4 hhh 0
5 jjj 0
6 uuu 0
28 hhhh 1
Hello,
it looks like hierarchical structure. QlikView has function Hierarchy() that could solve your problem in wider range.
I also attached you file with results, but not using hierarchy function.
BR
???
could you be more clear
how you are getting reporting count like 3,0,2.....
what / how you want the desired result?
Hello,
it looks like hierarchical structure. QlikView has function Hierarchy() that could solve your problem in wider range.
I also attached you file with results, but not using hierarchy function.
BR