topic sum in QlikView

sum

joelle_alhanna — Tue, 02 Feb 2021 15:11:37 GMT

hi,

I have the following question

I want to get the salesman related to a client but showing the sales of these salesman regardless of the client

for example:

Client 1 - Salesman1 - Sales 100

Client 1 - Salesman2 - Sales 200

Client 2 - Salesman1 - Sales 500

I want to show the following

Client1 - Sales 800

Client2 - Sales 600

any help please

Re: sum

edwin — Tue, 02 Feb 2021 19:12:19 GMT

What are the rules though? it looked like you credited the sales for Client2 to Client1 but not the other way around. what if there are 3 clients? how will QV know which clients to aggregate and which ones not to? you need to supply the rules as it cant be guessed at

Re: sum

joelle_alhanna — Wed, 03 Feb 2021 08:16:05 GMT

one client can be related to multiple salesmen.I want to add the total sales of these salesmen and assign it to the client.