topic URGENT : Problem with dimension - Aggr in QlikView

URGENT : Problem with dimension - Aggr

Sun, 27 Jun 2010 07:37:32 GMT

I have a dimension Group (group of products) and I have a target on each group. Let's say for the group1 the target is 100.

It means that customer should by 100 products of group1. I need to display the number of customers who reach this target

I use a pivot table with the dimension Group and an expression:

Count(distinct aggr(if ( sum(Qty)>Target, Customer),Customer))

It give me result but below what I expect but if I select one of the group I get the correct result.

Group1 4

Group2 6

if I select Group1

Group1 36

Do you know why I got a different result when I select one of the group ?

Thanks

URGENT : Problem with dimension

Or — Sun, 27 Jun 2010 09:46:23 GMT

Try:

Count(distinct aggr(if ( sum(Qty)>Target, Customer, Group),Customer))

URGENT : Problem with dimension

Sun, 27 Jun 2010 10:04:45 GMT

Try this

Count(distinct aggr(if ( sum(Qty)>=Target, Customer, Group),Customer))

Regards

ABDALLA

URGENT : Problem with dimension

Sun, 27 Jun 2010 11:21:19 GMT

I tried but I got the same result

URGENT : Problem with dimension

Or — Sun, 27 Jun 2010 11:54:49 GMT

Possibly QV is having trouble evaluating the Target in your function, but I'm not really sure - without a sample it's hard to tell or try different functions to see if any of them work.

URGENT : Problem with dimension

Sun, 27 Jun 2010 12:52:45 GMT

I put a number instead of Target. But I got the same result. Any other Idea ?

URGENT : Problem with dimension

Sun, 27 Jun 2010 16:42:34 GMT

I finally found the solution:

sum(if( aggr(sum(Qty),Group,Customer)>=Target,1,0))