topic Problem with aggr function in QlikView

Problem with aggr function

Mon, 26 Sep 2011 15:09:03 GMT

i have a problem to put the % of Quantity in this qvw per customer and product.the result is null and only in total is correct. The data is in the attach qvw.

Problem with aggr function

jedgson — Mon, 26 Sep 2011 15:12:09 GMT

Ilydaalex,

try putting NODISTINCT inside the aggr() function.

ie aggr(NODISTINCT <Expression>......)

Jay

Problem with aggr function

Mon, 26 Sep 2011 20:50:55 GMT

Jay, Thanks a lot.

I am trying to solve this problem for 3 days.

What is the difference between distinct and no distinct?

Problem with aggr function

jedgson — Tue, 27 Sep 2011 09:31:20 GMT

This is from the help:

"If the expression argument is preceded by the nodistinct qualifier, each combination of dimension values may generate more than one return value, depending on underlying data structure. If the expression argument is preceded by the distinct qualifier or if no qualifier is used at all, each combination of dimension values will generate only one return value."