Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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

View solution in original post

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