topic Count in Script # times Employee Name appears as Manager Name in QlikView

Count in Script # times Employee Name appears as Manager Name

Wed, 25 Nov 2020 16:16:04 GMT

Hi there, I suspect this is easier than I think it is!

I have a standard Headcount table including Employee_Name and Manager_Name fields.

I want to Join to this a Reportees field capturing the number of times each Employee_Name appears as a Manager_Name.

If it were Excel it would be a simple CountIf(range = Manager_Name column, condition = This Employee_Name)

Can anyone help me with this?

Thanks - Mike

Anil_Babu_Samineni — Tue, 11 Oct 2016 16:49:19 GMT

Perhaps This,

CountIf(range = Manager_Name column, condition = This Employee_Name)

Count({<range = {'$(=Only(Manager_Name))'}>}Employee_Name)

Count({<range = P(Manager_Name)>}Employee_Name)

Count({<range = $::Manager_Name}>}Employee_Name)

sunny_talwar — Tue, 11 Oct 2016 16:54:38 GMT

May be like this:

Headcount:

LOAD Employee_Name,

Manager_Name

FROM ....

Left Join (Headcount)

LOAD Manager_Name as Employee_Name,

Count(Manager_Name) as Count

Resident Headcount

Group By Manager_Name;

Wed, 12 Oct 2016 09:54:49 GMT

Worked like a charm, thanks very much!

sunny_talwar — Wed, 12 Oct 2016 16:01:21 GMT

Awesome!! I am glad it did. I would suggest you to close this thread by marking correct and/or helpful responses.

Best,

Sunny