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: 
Anonymous
Not applicable

Qlikview valuelist() and aggr() for nodistinct

Hello everyone,

     I want to group the total amount by order number;The issue is Qty1: No value through the first algorithm,and Qty2: aggr( nodistict())    No grouping by order number;


Do you have any idea?

Thanks,for any help in adavance.

Best regards !

5 Replies
sunny_talwar

What exactly is the output you are hoping to see?

Anonymous
Not applicable
Author

The Qty2 result is wrong,It counts the article number instead of the order number, and  the   Qty1 expression written has no value

sunny_talwar

What are the numbers you expect to see in the chart?

Anonymous
Not applicable
Author

That is the Qty2  result  ;Qty1 Should be a grammar question,but  I cant find the problem;

resultQty2.png@

gp_oconnor
Partner - Contributor III
Partner - Contributor III

Please see attached.  I changed the approach to no longer use a ValueList() but rather an Aggr() to create a calculated dimension.  This significantly simplifies the expressions for the measures.  There is an additional chart in the attachment showing this.

Hope this helps.