Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, i have a dinamic table where i have to show the total number clients assigned to salesperson, i have this information in table clients.
I am using this expression but the result is not correct
Aggr(Count (DISTINCT %CodCliente),%CodVendedor)
Dimension:
%CodVendedor
Expression:
Count (DISTINCT %CodCliente)
is not working?
This expression has customers which the seller sold them, i need to count the clients that the seller has assigned and which appear in customers tables, for examples in table customers
Client Salesperson
A Carlos
B Luis
C Maria
D Carlos
E Carlos
F Carlos
G Luis
H Maria
I should have:
SalesPerson #Clients
Carlos 4
Luis 2
Maria 2
I am doing a query and work, but i don´t know my mistake in qlik
select CodigoVendededor,count(CodigoCliente) from clientes group by CodigoVendedor
In expression, where you have signed sales person?
I agree marco suggestion simply
You can try this to
Aggr(Count ({<salesperson>} DISTINCT %CodCliente),%CodVendedor)
Hello Anil, thanks for your reply, but i don´t select the sales person, i need to count total clients assigned to salesperson
Try with simple
Dimension as sales person
Expression is count(client)
Or
Count(total client)
This should be straight table or pivot table
Hi Elina,
May be like this
See below script and attached file
Data:
LOAD Count(Client) as Client ,
Salesperson
INLINE [
Client , Salesperson
A , Carlos
B , Luis
C , Maria
D , Carlos
E , Carlos
F , Carlos
G , Luis
H , Maria
] Group By Salesperson;
I hope this helps you.....
-Nagarjun
Are you looking for this??
If yes then, I think it needs simple Count of client with SalesPerson as dimension
Thanks, for yours reply, i can to resolve this issue
In my ETL in clients table i am using AutoNumber(RowNo(),VendedorCliente) as Num,
And in my application with Dimension Salesman and expression Aggr(Max(Num),VendedorCliente)
Hello, i have a little problem, now i need to show the names of clients, i am using a script like post for
Data:
LOAD Count(Client) as Client ,
Salesperson
INLINE [
Client , Salesperson
A , Carlos
B , Luis
C , Maria
D , Carlos
E , Carlos
F , Carlos
G , Luis
H , Maria
] Group By Salesperson;