topic Sum based on "white" values in QlikView

Sum based on "white" values

mbylicki — Thu, 24 May 2018 22:14:55 GMT

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

Re: Sum based on "white" values

ogautier62 — Fri, 25 May 2018 07:42:24 GMT

Hi,

you can use something like :

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

field = ClientName for example

regards

Re: Sum based on "white" values

sunny_talwar — Fri, 25 May 2018 11:41:35 GMT

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ół>}%)