topic Re: Do I need AGGR ? Or something else in QlikView

Do I need AGGR ? Or something else

petermoyaert — Wed, 25 Nov 2020 16:16:04 GMT

I created a table in which I Can see for each account manager its sales and numer of customers for a specific supplier.

I want to set off this number of customers against the total number of customers of each account manager.

However I do not succeed in adding the right formula to see the total number of customers of each account manager. It is Always reduced to the number of customers of the selected supplier.

Who can help ?

Re: Do I need AGGR ? Or something else

YoussefBelloum — Thu, 09 Nov 2017 10:10:15 GMT

Hi,

have you tried Aggr ?

Aggr(sum(sales),AccountManager,Supplier)

Re: Do I need AGGR ? Or something else

petermoyaert — Thu, 09 Nov 2017 10:27:23 GMT

AGGR(count({<Jaar_Kalender={$(=Only(Jaar_Kalender))}, Omschrijving_Merk={'Duvo+'} >}distinct Nummer_Klant), Naam_Vertegenwoordiger, Naam_Leverancier)

and

count({<Jaar_Kalender={$(=Only(Jaar_Kalender))}, Omschrijving_Merk={'Duvo+'} >}distinct Nummer_Klant)

result both in the same result and that's the number of customers where the products of the selected suppliers are sold.

I need this information, but I also want to know the total numer of customers of the account manager, to see what"s the potential.

Re: Do I need AGGR ? Or something else

YoussefBelloum — Thu, 09 Nov 2017 10:29:32 GMT

Try to give just sample data with your QVW

Re: Do I need AGGR ? Or something else

petermoyaert — Thu, 09 Nov 2017 10:35:39 GMT

So in the last 2 columns I get the same result. However in the last column I want to know how many customers in total this account manager has in portfolio. In this case 75, so there are 20 customers in his portfolio that do not buy the products of the selected supplier.

Re: Do I need AGGR ? Or something else

YoussefBelloum — Thu, 09 Nov 2017 10:38:50 GMT

ok, i see, but i was talking about the send just a a couple of lines from the source file and the app !

Re: Do I need AGGR ? Or something else

petermoyaert — Thu, 09 Nov 2017 10:50:07 GMT

Don't know how to do that, but I just found out, based on your suggestion !

In the AGGR function I need to exclude the supplier. Than it works !

Thanks

Re: Do I need AGGR ? Or something else

YoussefBelloum — Thu, 09 Nov 2017 10:57:09 GMT

COOL !

next time try to upload your app+ sample data to the community that they can quickly help

you need to do this:

at the end, don't forget to always mark the helpful answers as helpful, and the correct answer as correct !

Good luck !