expression help

[vinay_hg]

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

[vinay_hg]

???

[#3]

could you be more clear

how you are getting reporting count like 3,0,2.....

what / how you want the desired result?

[mato32188 · Accepted solution]

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