Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with aggr function

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.

1 Solution

Accepted Solutions
jedgson
Creator
Creator

Ilydaalex,

try putting NODISTINCT inside the aggr() function.

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

Jay

View solution in original post

3 Replies
jedgson
Creator
Creator

Ilydaalex,

try putting NODISTINCT inside the aggr() function.

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

Jay

Not applicable
Author

Jay, Thanks a lot.

I am trying to solve this problem for 3 days.

What is the difference between distinct and no distinct?

jedgson
Creator
Creator

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."