Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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ół>}%)
Hi,
you can use something like :
<field = {'=len(trim(field)) = 0'} > or -= to exclude
field = ClientName for example
regards
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ół>}%)