topic Re: Show all names around current selection in QlikView

Show all names around current selection

pauldamen — Mon, 21 Dec 2015 10:53:49 GMT

All,

I have a sheet where information provided is per employee. The employee is selected in a listbox.

On the tab I also have a table where I want to show a benchmark of all team members of the team where the selected employee is in, with some figures.

How do I show the numbers for all the teammembers belonging to the team the selected teammember is in even though 1 employee is selected?

Regards, Paul

sunny_talwar — Mon, 21 Dec 2015 10:56:29 GMT

May be this in the set analysis:

{<Employee, Team = p(Team)>}

lironbaram — Mon, 21 Dec 2015 10:58:34 GMT

your expression should look like this

sum({<employee=,Team=p(Team)>}X)

this way in the expression you disregard the selection in the employee field

but you select to display only teams that are in the current selection set of data

pauldamen — Mon, 21 Dec 2015 11:00:05 GMT

Thanks for the quick explanation, works like a charm