Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a requirement to display the count of team members for all the managers other than selected manager.
I have written this expression - Count(DISTINCT{<manager-={'$(VGetManager)'}>} memberid)
Variable VGetManager = GetFieldSelections(manager)
But this is working exactly opposite. If i select manager name than it gives me count of members associated with that manager. I want the count of not associated members.
I read about P and E function but not understand how to use in my case.
Please suggest the expression.
Thanks.
Regards,
Neha
Thanks for confirming Neha,
Can you please close this thread my marking correct response, and also mark responses that were helpful
Qlik Community Tip: Marking Replies as Correct or Helpful