topic Re: exclude values of current selection in set analysis in QlikView

exclude values of current selection in set analysis

nehasaxena — Fri, 10 Mar 2017 10:27:54 GMT

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

Re: exclude values of current selection in set analysis

dsharmaqv — Fri, 10 Mar 2017 10:29:59 GMT

try this

Count(DISTINCT{<manager={'*'}-{'$(VGetManager)'}>} memberid)

Re: exclude values of current selection in set analysis

Fri, 10 Mar 2017 10:37:28 GMT

Hi,

Use '1-$' in place of '$' this will give you excluded results,

Thanks

Re: exclude values of current selection in set analysis

tresB — Fri, 10 Mar 2017 10:41:08 GMT

Try like:

Count(DISTINCT{<manager=-$::manager>} memberid)

Re: exclude values of current selection in set analysis

praveenak — Fri, 10 Mar 2017 10:56:52 GMT

Hi Neha,

Try the below expressions,

count({$<manager=E({<manager={$(=getfieldselections(manager))}>}manager)>}memberid)

Thanks

Re: exclude values of current selection in set analysis

vinieme12 — Fri, 10 Mar 2017 11:06:58 GMT

just this will do

Count(DISTINCT{<manager=E(manager)>} memberid)

Re: exclude values of current selection in set analysis

praveenak — Fri, 10 Mar 2017 11:13:45 GMT

Hi Vineet,

Not an offense but your expression will show 'No data to display' when there is no selection made in the filed 'manager'

Thanks

Re: exclude values of current selection in set analysis

vinieme12 — Fri, 10 Mar 2017 11:27:02 GMT

None taken; but there is no need to complicate it unnecessarily it's for the OP to decide what he want

Re: exclude values of current selection in set analysis

nehasaxena — Thu, 23 Mar 2017 06:40:46 GMT

Thanks Vineeth. I used this because we want to show data only when manager is selected.

Re: exclude values of current selection in set analysis

nehasaxena — Thu, 23 Mar 2017 06:41:33 GMT

This expression is not working

Re: exclude values of current selection in set analysis

vinieme12 — Thu, 23 Mar 2017 10:45:51 GMT

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