Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Ilydaalex,
try putting NODISTINCT inside the aggr() function.
ie aggr(NODISTINCT <Expression>......)
Jay
Ilydaalex,
try putting NODISTINCT inside the aggr() function.
ie aggr(NODISTINCT <Expression>......)
Jay
Jay, Thanks a lot.
I am trying to solve this problem for 3 days.
What is the difference between distinct and no distinct?
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."