Sum based on "white" values

[mbylicki]

Dear QV Masters,

I try to solved such problem - how to sum the data based on "white" values in a field. I enclosed the qvw for best understanding my problem.

QVW includes information such:

- Client list

- Employee list

- Team list

- % time engagement for each Employee by Client

When you select a Team table "% time engagement" tells us all necessary information which is obvious.

My problem is - how to create another table which will contain simillar information but will present all Employees from team MBI and TV working with the Clients which are now listed white in Client list.

Example - when you select Team ACZ you will notice that there are Employees 4, 18, 19, 55, 57, 107 working with Clients 36, 37, 74, 75, 82, 94, 95, 101. I try to create lower table which should give me information about above mentioned Clients and all Employees working with them, so I need to have Employees 24, 36, 48, 61, 72, 75, 81, 85, 88, 96, 109, 113, 115

Could you please help me with Set analysis.

Thank you

Maciej

[ogautier62]

Hi,

you can use something like :

<field = {'=len(trim(field)) = 0'} >  or -= to exclude

field = ClientName for example

regards

[sunny_talwar · Accepted solution]

When I select Clients 36, 37, 74, 75, 82, 94, 95, 101... I see this

Is this what you wish to see when ACZ is selected in a new table? I got confused because you mentioned seeing only these Employees 24, 36, 48, 61, 72, 75, 81, 85, 88, 96, 109, 113, 115.. why not 2 or 117 etc?

If above out put is what you want to see when ACZ is selected... try this

=Sum({<[Imię Nazwisko], Klient = P(Klient), Zespół>}%)