Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Perhaps This,
CountIf(range = Manager_Name column, condition = This Employee_Name)
Count({<range = {'$(=Only(Manager_Name))'}>}Employee_Name)
OR
Count({<range = P(Manager_Name)>}Employee_Name)
OR
Count({<range = $::Manager_Name}>}Employee_Name)
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;
Worked like a charm, thanks very much!
Awesome!! I am glad it did. I would suggest you to close this thread by marking correct and/or helpful responses.
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny