topic Re: Aggr function in QlikView

Aggr function

Thu, 21 Nov 2013 21:59:26 GMT

Hello everyone,

I have a problem when i'm using the aggr function.

I have the number of sales per store(DEALER_NAME):

i'm using the following expression : = count({1} SALES)

Each store has salesman and I'm trying to get the participation of each salesman in their stores.

I'm using : =count(SALES)/sum(Aggr(NODISTINCT count({1}>} SALES),DEALER_NAME)

but for the store 4, I get some weird results.

So I put the following expression in a text object :

=SUM(Aggr(NODISTINCT count({1< DEALER_NAME = {'Store 4'}>} SALES),DEALER_NAME))

and it gives me 62469 as a result and I don't understand why.

Anyone has a clue ?

Thanks for your help

Sadjad

Re: Aggr function

jagan — Fri, 22 Nov 2013 03:08:37 GMT

Hi,

Can you attach sample data and file, it helps in understanding easily. I think count(SALES) is enough to get the number of Sales per Dealer since dealer is used as dimension.

Regards,

Jagan.

Re: Aggr function

Fri, 22 Nov 2013 05:58:07 GMT

Hi Sadjad,

Hope the below expression helps!

=count(SALES)/count({1} total SALES)

Vinoth

Re: Aggr function

Fri, 22 Nov 2013 06:25:23 GMT

try this

=count(SALES)/count(All SALES)

or this one

=count(SALES)/sum({1} count(SALES))

Re: Aggr function

Fri, 22 Nov 2013 15:17:38 GMT

Thanks guys but finally the problem was in the data.