topic Re: Excluding one selection in QlikView

Excluding one selection

Tue, 18 Nov 2014 22:35:52 GMT

Hi,

I have a 2 list boxes. One with Manager information and one with Employee information. When I click on a manager name 'Bob', a list of employee names are associated with it. I want to select all but one particular employee named as " UNASSIGNED".

I have created a text object where I am trying to set actions which will automatically select all the employees in the list box under one particular manager except " UNASSIGNED".. I am unable to do it.

There are also some Managers who doesn't have any UNASSIGNED employee. When I use " Select Possible" there, it works fine. But, when I am trying to get rid of " UNASSIGNED" from an already made selection, it doesn't work.

Is there a function which will help exclude one from all the current field selection?

Thanks,

Tutan

Re: Excluding one selection

danieloberbilli — Tue, 18 Nov 2014 22:59:45 GMT

Hi, just as an idea...but its probably not the best solution as a second click on the button will include the unassigned again.

Please find the qvw attached.

Re: Excluding one selection

danieloberbilli — Tue, 18 Nov 2014 23:02:23 GMT

sorry - I forgot to include select Manager 1 in the button. Please find correct app attached

Re: Excluding one selection

Tue, 18 Nov 2014 23:07:30 GMT

I did not know very well. thank you

Re: Excluding one selection

ashfaq_haseeb — Wed, 19 Nov 2014 04:53:47 GMT

Hi,

Check if this helps.

Regards

ASHFAQ

Re: Excluding one selection

Wed, 19 Nov 2014 19:56:28 GMT

Thanks for the help. Somehow this is not what I am looking for. I have thought of an alternative. How can I hide/show a text object based on a selection?

For eg: I click on a list box called Manager Name, Bob....by qlikview's associative nature all the employees ( another list box) get auto linked in white. Out of the list of these associated employees if one of them is called " UNASSIGNED", I will hide a text box, else show it. How can I do it?

Regards,

Tutan

Re: Re: Excluding one selection

danieloberbilli — Wed, 19 Nov 2014 22:26:07 GMT

Please find QVW attached.