exclude values of current selection in set analysis

[nehasaxena]

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

[vinieme12]

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